home *** CD-ROM | disk | FTP | other *** search
| Unknown | 1985-08-20 | 108.9 KB |
open in: 
MacOS 8.1
|
Win98
|
DOS
view JSON data
|
view as text
This file was not able to be converted.
This format is not currently supported by dexvert.
| Confidence | Program | Detection | Match Type | Support
|
|---|
| 1%
| dexvert
| Forgotten Worlds music (music/forgottenWorldsMusic)
| ext
| Unsupported |
| 100%
| file
| data
| default
|
|
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 03 00 6e 01 00 ff ed fb | 00 00 00 00 42 00 00 00 |..n.....|....B...|
|00000010| 9f 78 c2 34 02 03 16 03 | 30 00 00 00 00 00 00 00 |.x.4....|0.......|
|00000020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000030| 04 00 1c 02 08 0a 00 00 | 00 00 00 00 02 00 00 00 |........|........|
|00000040| 00 00 00 00 00 00 00 00 | 04 00 38 00 0a 00 0b 00 |........|..8.....|
|00000050| 0c 00 0b 00 0d 01 13 00 | db 02 14 06 c2 08 a2 0b |........|........|
|00000060| c6 0d 9e 0f 48 12 4e 14 | 84 15 eb 17 0d 00 0d 00 |....H.N.|........|
|00000070| 04 00 1e 02 02 ff 05 41 | 01 00 01 00 4e 00 13 00 |.......A|....N...|
|00000080| 01 00 02 00 4e 00 14 00 | 00 00 01 00 4f 00 15 00 |....N...|....O...|
|00000090| 00 00 01 00 12 00 02 00 | 01 00 02 00 08 00 00 00 |........|........|
|000000a0| 00 00 00 00 01 00 0b 00 | ff 08 00 00 00 00 00 00 |........|........|
|000000b0| 02 00 20 02 18 82 00 00 | 00 01 00 00 02 00 07 00 |.. .....|........|
|000000c0| 46 57 54 4e 4f 54 45 00 | ff ff ff ff ff ff ff ff |FWTNOTE.|........|
|000000d0| 09 00 22 02 18 82 00 00 | 00 01 00 00 02 00 6c 00 |..".....|......l.|
|000000e0| 3b 41 73 68 74 6f 6e 2d | 54 61 74 65 20 46 72 61 |;Ashton-|Tate Fra|
|000000f0| 6d 65 77 6f 72 6b 20 54 | 65 63 68 6e 69 63 61 6c |mework T|echnical|
|00000100| 20 4e 6f 74 65 73 ff 01 | 00 ff 40 68 70 28 32 29 | Notes..|..@hp(2)|
|00000110| 2c 40 68 6c 28 22 00 07 | 41 73 68 74 6f 6e 2d 54 |,@hl("..|Ashton-T|
|00000120| 61 74 65 20 46 72 61 6d | 65 77 6f 72 6b 20 54 65 |ate Fram|ework Te|
|00000130| 63 68 6e 69 63 61 6c 20 | 4e 6f 74 65 73 00 00 22 |chnical |Notes.."|
|00000140| 29 2c 40 68 72 28 22 00 | 07 50 61 67 65 00 00 20 |),@hr(".|.Page.. |
|00000150| 22 26 40 70 6e 29 00 ff | ff ff ff ff ff ff ff ff |"&@pn)..|........|
|00000160| bf 02 24 02 18 80 00 00 | 00 02 00 00 02 00 00 00 |..$.....|........|
|00000170| 00 00 00 00 00 00 00 00 | d2 02 1c 02 d9 02 01 00 |........|........|
|00000180| 02 00 48 2b 0d 01 20 20 | 20 20 62 79 20 4b 65 6e |..H+.. | by Ken|
|00000190| 74 20 49 72 77 69 6e ff | 02 00 4b 20 ff 02 00 4b |t Irwin.|..K ...K|
|000001a0| 00 04 49 6e 74 72 6f 64 | 75 63 74 69 6f 6e ff 02 |..Introd|uction..|
|000001b0| 00 4b ff 02 00 4b 00 00 | 59 6f 75 20 73 61 79 20 |.K...K..|You say |
|000001c0| 79 6f 75 20 6a 75 73 74 | 20 64 6f 6e 27 74 20 75 |you just| don't u|
|000001d0| 6e 64 65 72 73 74 61 6e | 64 20 46 52 45 44 3f 20 |nderstan|d FRED? |
|000001e0| 20 59 6f 75 27 76 65 20 | 77 6f 72 6b 65 64 20 79 | You've |worked y|
|000001f0| 6f 75 72 20 77 61 79 20 | 74 68 72 6f 75 67 68 20 |our way |through |
|00000200| 74 68 65 0d 54 75 74 6f | 72 69 61 6c 20 61 6e 64 |the.Tuto|rial and|
|00000210| 2c 20 20 73 75 72 65 2c | 20 20 65 76 65 72 79 74 |, sure,| everyt|
|00000220| 68 69 6e 67 20 69 73 20 | 72 65 61 6c 20 6e 65 61 |hing is |real nea|
|00000230| 74 20 61 6e 64 20 73 70 | 69 66 66 79 20 69 6e 20 |t and sp|iffy in |
|00000240| 46 72 61 6d 65 77 6f 72 | 6b 2e 20 20 42 75 74 0d |Framewor|k. But.|
|00000250| 79 6f 75 20 64 6f 6e 27 | 74 20 75 6e 64 65 72 73 |you don'|t unders|
|00000260| 74 61 6e 64 20 68 6f 77 | 20 74 6f 20 74 69 65 20 |tand how| to tie |
|00000270| 69 74 20 61 6c 6c 20 74 | 6f 67 65 74 68 65 72 3f |it all t|ogether?|
|00000280| 20 20 20 59 6f 75 27 64 | 20 6c 69 6b 65 20 20 74 | You'd| like t|
|00000290| 6f 20 63 75 73 74 6f 6d | 69 7a 65 0d 46 72 61 6d |o custom|ize.Fram|
|000002a0| 65 77 6f 72 6b 20 74 6f | 20 79 6f 75 72 20 6f 77 |ework to| your ow|
|000002b0| 6e 20 64 61 69 6c 79 20 | 74 61 73 6b 73 2c 20 20 |n daily |tasks, |
|000002c0| 62 75 74 20 6a 75 73 74 | 20 63 61 6e 27 74 20 66 |but just| can't f|
|000002d0| 69 67 75 72 65 20 20 6f | 75 74 20 68 6f 77 3f 20 |igure o|ut how? |
|000002e0| 20 59 6f 75 27 76 65 0d | 68 65 61 72 64 20 70 65 | You've.|heard pe|
|000002f0| 6f 70 6c 65 20 74 61 6c | 6b 20 61 62 6f 75 74 20 |ople tal|k about |
|00000300| 22 70 72 6f 67 72 61 6d | 73 22 20 20 69 6e 20 46 |"program|s" in F|
|00000310| 72 61 6d 65 77 6f 72 6b | 2c 20 20 61 6e 64 20 64 |ramework|, and d|
|00000320| 6f 6e 27 74 20 6b 6e 6f | 77 20 77 68 61 74 20 74 |on't kno|w what t|
|00000330| 68 65 79 0d 6d 65 61 6e | 3f 20 20 20 54 61 6b 65 |hey.mean|? Take|
|00000340| 20 68 65 61 72 74 2c 20 | 20 62 65 63 61 75 73 65 | heart, | because|
|00000350| 20 74 68 69 73 20 20 6e | 65 77 20 73 65 72 69 65 | this n|ew serie|
|00000360| 73 20 20 77 69 6c 6c 20 | 20 74 61 6b 65 20 79 6f |s will | take yo|
|00000370| 75 20 6f 6e 20 61 20 20 | 74 6f 75 72 20 6f 66 0d |u on a |tour of.|
|00000380| 46 72 61 6d 65 77 6f 72 | 6b 20 20 74 68 72 6f 75 |Framewor|k throu|
|00000390| 67 68 20 74 68 65 20 65 | 79 65 73 20 20 6f 66 20 |gh the e|yes of |
|000003a0| 46 52 45 44 2c 20 20 61 | 6e 64 20 61 6c 6c 20 77 |FRED, a|nd all w|
|000003b0| 69 74 68 6f 75 74 20 6c | 65 61 76 69 6e 67 20 20 |ithout l|eaving |
|000003c0| 79 6f 75 72 20 6c 69 76 | 69 6e 67 0d 72 6f 6f 6d |your liv|ing.room|
|000003d0| 20 61 72 6d 63 68 61 69 | 72 2e 20 20 20 54 6f 67 | armchai|r. Tog|
|000003e0| 65 74 68 65 72 20 20 77 | 65 20 20 77 69 6c 6c 20 |ether w|e will |
|000003f0| 20 65 78 70 6c 6f 72 65 | 20 74 68 65 20 20 73 69 | explore| the si|
|00000400| 6d 70 6c 65 73 74 20 20 | 61 70 70 6c 69 63 61 74 |mplest |applicat|
|00000410| 69 6f 6e 73 20 6f 66 0d | 66 6f 72 6d 75 6c 61 73 |ions of.|formulas|
|00000420| 20 69 6e 20 73 70 72 65 | 61 64 73 68 65 65 74 73 | in spre|adsheets|
|00000430| 3b 20 20 70 72 6f 70 65 | 72 20 75 73 65 20 6f 66 |; prope|r use of|
|00000440| 20 74 68 65 20 6f 6d 69 | 6e 6f 75 73 2d 73 6f 75 | the omi|nous-sou|
|00000450| 6e 64 69 6e 67 20 20 6d | 61 63 72 6f 73 3b 20 68 |nding m|acros; h|
|00000460| 6f 77 2c 0d 77 68 65 72 | 65 2c 20 20 77 68 79 2c |ow,.wher|e, why,|
|00000470| 20 20 61 6e 64 20 20 77 | 68 61 74 20 20 74 6f 20 | and w|hat to |
|00000480| 20 64 6f 20 20 77 69 74 | 68 20 70 72 6f 67 72 61 | do wit|h progra|
|00000490| 6d 73 3b 20 20 6c 69 6e | 6b 69 6e 67 20 64 69 66 |ms; lin|king dif|
|000004a0| 66 65 72 65 6e 74 20 74 | 79 70 65 73 20 6f 66 0d |ferent t|ypes of.|
|000004b0| 66 72 61 6d 65 73 3b 20 | 20 61 6e 64 20 6f 74 68 |frames; | and oth|
|000004c0| 65 72 20 20 74 6f 70 69 | 63 73 20 20 77 68 69 63 |er topi|cs whic|
|000004d0| 68 20 20 77 69 6c 6c 20 | 20 69 6e 74 65 72 65 73 |h will | interes|
|000004e0| 74 20 20 46 72 61 6d 65 | 77 6f 72 6b 20 20 75 73 |t Frame|work us|
|000004f0| 65 72 73 20 20 6f 66 20 | 61 6c 6c 0d 65 78 70 65 |ers of |all.expe|
|00000500| 72 69 65 6e 63 65 20 6c | 65 76 65 6c 73 2e 20 20 |rience l|evels. |
|00000510| 20 46 6f 72 20 6f 62 76 | 69 6f 75 73 20 20 72 65 | For obv|ious re|
|00000520| 61 73 6f 6e 73 2c 20 20 | 69 74 20 20 77 69 6c 6c |asons, |it will|
|00000530| 20 20 62 65 20 20 61 73 | 73 75 6d 65 64 20 20 66 | be as|sumed f|
|00000540| 72 6f 6d 20 74 68 65 0d | 62 65 67 69 6e 6e 69 6e |rom the.|beginnin|
|00000550| 67 20 74 68 61 74 20 79 | 6f 75 20 68 61 76 65 20 |g that y|ou have |
|00000560| 20 63 6f 6d 70 6c 65 74 | 65 64 20 74 68 65 20 46 | complet|ed the F|
|00000570| 72 61 6d 65 77 6f 72 6b | 20 54 75 74 6f 72 69 61 |ramework| Tutoria|
|00000580| 6c 20 20 6d 61 6e 75 61 | 6c 2c 20 20 61 6e 64 20 |l manua|l, and |
|00000590| 61 72 65 0d 72 65 6c 61 | 74 69 76 65 6c 79 20 66 |are.rela|tively f|
|000005a0| 61 6d 69 6c 69 61 72 20 | 20 77 69 74 68 20 20 74 |amiliar | with t|
|000005b0| 68 65 20 46 72 61 6d 65 | 77 6f 72 6b 20 73 79 73 |he Frame|work sys|
|000005c0| 74 65 6d 2c 20 20 69 6e | 63 6c 75 64 69 6e 67 20 |tem, in|cluding |
|000005d0| 74 68 65 20 20 75 73 65 | 20 6f 66 20 74 68 65 0d |the use| of the.|
|000005e0| 73 70 65 63 69 61 6c 20 | 20 66 75 6e 63 74 69 6f |special | functio|
|000005f0| 6e 20 20 6b 65 79 73 20 | 20 28 4d 4f 56 45 2c 20 |n keys | (MOVE, |
|00000600| 20 43 4f 50 59 2c 20 20 | 45 44 49 54 2c 20 44 4e | COPY, |EDIT, DN|
|00000610| 4c 45 56 45 4c 2c 20 65 | 74 63 2e 29 2c 20 74 68 |LEVEL, e|tc.), th|
|00000620| 65 20 70 75 6c 6c 2d 64 | 6f 77 6e 0d 6d 65 6e 75 |e pull-d|own.menu|
|00000630| 73 2c 20 20 74 68 65 20 | 20 62 61 73 69 63 20 66 |s, the | basic f|
|00000640| 72 61 6d 65 20 74 79 70 | 65 73 2c 20 20 61 6e 64 |rame typ|es, and|
|00000650| 20 6c 6f 61 64 69 6e 67 | 20 61 6e 64 20 20 73 61 | loading| and sa|
|00000660| 76 69 6e 67 20 20 66 69 | 6c 65 73 2e 20 20 20 54 |ving fi|les. T|
|00000670| 68 65 20 63 6f 6e 2d 0d | 76 65 6e 74 69 6f 6e 20 |he con-.|vention |
|00000680| 49 20 77 69 6c 6c 20 75 | 73 65 20 69 6e 20 74 68 |I will u|se in th|
|00000690| 69 73 20 73 65 72 69 65 | 73 20 6f 66 20 61 72 74 |is serie|s of art|
|000006a0| 69 63 6c 65 73 20 20 69 | 73 20 74 6f 20 75 6e 64 |icles i|s to und|
|000006b0| 65 72 6c 69 6e 65 20 20 | 74 68 65 20 6c 69 74 65 |erline |the lite|
|000006c0| 72 61 6c 0d 74 68 69 6e | 67 73 20 69 6e 20 74 68 |ral.thin|gs in th|
|000006d0| 65 20 74 65 78 74 20 79 | 6f 75 20 73 68 6f 75 6c |e text y|ou shoul|
|000006e0| 64 20 74 79 70 65 20 69 | 6e 20 6f 72 20 63 68 61 |d type i|n or cha|
|000006f0| 6e 67 65 2e 20 20 48 6f | 77 65 76 65 72 2c 20 69 |nge. Ho|wever, i|
|00000700| 6e 64 65 6e 74 65 64 20 | 70 72 6f 67 72 61 6d 0d |ndented |program.|
|00000710| 6c 69 73 74 69 6e 67 73 | 20 77 69 6c 6c 20 6e 6f |listings| will no|
|00000720| 74 20 62 65 20 75 6e 64 | 65 72 6c 69 6e 65 64 20 |t be und|erlined |
|00000730| 66 6f 72 20 74 68 65 20 | 73 61 6b 65 20 6f 66 20 |for the |sake of |
|00000740| 72 65 61 64 61 62 69 6c | 69 74 79 2e 20 20 20 53 |readabil|ity. S|
|00000750| 6f 2c 20 77 69 74 68 20 | 74 68 65 0d 62 61 73 69 |o, with |the.basi|
|00000760| 63 73 20 62 65 68 69 6e | 64 20 20 79 6f 75 2c 20 |cs behin|d you, |
|00000770| 20 61 6e 64 20 46 52 45 | 44 20 62 65 66 6f 72 65 | and FRE|D before|
|00000780| 20 79 6f 75 2c 20 20 70 | 75 6c 6c 20 75 70 20 79 | you, p|ull up y|
|00000790| 6f 75 72 20 20 61 72 6d | 63 68 61 69 72 20 61 6e |our arm|chair an|
|000007a0| 64 20 77 65 27 6c 6c 0d | 64 69 76 65 20 72 69 67 |d we'll.|dive rig|
|000007b0| 68 74 20 69 6e 2e ff 02 | 00 4b 20 ff 02 00 4b 22 |ht in...|.K ...K"|
|000007c0| 41 6c 6c 20 74 68 65 20 | 77 6f 72 6c 64 20 69 73 |All the |world is|
|000007d0| 20 66 72 61 6d 65 73 2c | 22 20 20 53 68 61 6b 65 | frames,|" Shake|
|000007e0| 73 70 65 61 72 65 20 6f | 6e 63 65 20 73 61 69 64 |speare o|nce said|
|000007f0| 20 28 6f 72 20 73 6f 6d | 65 74 68 69 6e 67 20 6c | (or som|ething l|
|00000800| 69 6b 65 20 74 68 61 74 | 29 2c 0d 61 6e 64 20 73 |ike that|),.and s|
|00000810| 75 72 65 6c 79 20 68 65 | 20 77 61 73 20 74 61 6c |urely he| was tal|
|00000820| 6b 69 6e 67 20 61 62 6f | 75 74 20 46 72 61 6d 65 |king abo|ut Frame|
|00000830| 77 6f 72 6b 2e 20 20 20 | 54 68 65 20 66 72 61 6d |work. |The fram|
|00000840| 65 20 69 73 20 74 68 65 | 20 62 61 73 69 63 20 75 |e is the| basic u|
|00000850| 6e 69 74 20 6f 66 0d 6f | 70 65 72 61 74 69 6f 6e |nit of.o|peration|
|00000860| 20 74 68 72 6f 75 67 68 | 6f 75 74 20 46 72 61 6d | through|out Fram|
|00000870| 65 77 6f 72 6b 20 69 6e | 20 74 68 65 20 73 61 6d |ework in| the sam|
|00000880| 65 20 20 77 61 79 20 74 | 68 61 74 20 73 68 65 65 |e way t|hat shee|
|00000890| 74 73 20 6f 66 20 20 70 | 61 70 65 72 20 63 6f 75 |ts of p|aper cou|
|000008a0| 6c 64 0d 62 65 20 63 6f | 6e 73 69 64 65 72 65 64 |ld.be co|nsidered|
|000008b0| 20 74 68 65 20 62 61 73 | 69 63 20 75 6e 69 74 73 | the bas|ic units|
|000008c0| 20 6f 66 20 79 6f 75 72 | 20 6f 66 66 69 63 65 20 | of your| office |
|000008d0| 20 64 65 73 6b 74 6f 70 | 2e 20 20 20 49 6e 20 66 | desktop|. In f|
|000008e0| 61 63 74 2c 20 49 20 6c | 69 6b 65 20 74 6f 0d 74 |act, I l|ike to.t|
|000008f0| 68 69 6e 6b 20 6f 66 20 | 66 72 61 6d 65 73 20 69 |hink of |frames i|
|00000900| 6e 20 6a 75 73 74 20 74 | 68 61 74 20 77 61 79 3b |n just t|hat way;|
|00000910| 20 61 73 20 73 68 65 65 | 74 73 20 6f 66 20 70 61 | as shee|ts of pa|
|00000920| 70 65 72 2e 20 20 54 68 | 69 6e 6b 20 61 62 6f 75 |per. Th|ink abou|
|00000930| 74 20 69 74 3a 20 77 68 | 65 6e 0d 79 6f 75 20 44 |t it: wh|en.you D|
|00000940| 52 41 47 20 61 20 66 72 | 61 6d 65 2c 20 69 74 27 |RAG a fr|ame, it'|
|00000950| 73 20 6c 69 6b 65 20 70 | 75 73 68 69 6e 67 20 61 |s like p|ushing a|
|00000960| 20 73 68 65 65 74 20 61 | 63 72 6f 73 73 20 79 6f | sheet a|cross yo|
|00000970| 75 72 20 64 65 73 6b 2e | 20 20 41 6e 64 20 77 68 |ur desk.| And wh|
|00000980| 65 6e 20 79 6f 75 0d 43 | 72 65 61 74 65 20 61 20 |en you.C|reate a |
|00000990| 6e 65 77 20 66 72 61 6d | 65 2c 20 20 79 6f 75 27 |new fram|e, you'|
|000009a0| 72 65 20 70 75 6c 6c 69 | 6e 67 20 6f 75 74 20 61 |re pulli|ng out a|
|000009b0| 20 6e 65 77 20 73 68 65 | 65 74 20 6f 66 20 70 61 | new she|et of pa|
|000009c0| 70 65 72 20 61 6e 64 20 | 73 65 74 74 69 6e 67 20 |per and |setting |
|000009d0| 69 74 0d 6f 6e 20 20 79 | 6f 75 72 20 20 64 65 73 |it.on y|our des|
|000009e0| 6b 20 74 6f 20 73 74 61 | 72 74 20 61 20 6e 65 77 |k to sta|rt a new|
|000009f0| 20 64 6f 63 75 6d 65 6e | 74 2e 20 20 20 54 68 65 | documen|t. The|
|00000a00| 20 66 6f 72 6d 75 6c 61 | 20 70 6f 72 74 69 6f 6e | formula| portion|
|00000a10| 20 20 6f 66 20 20 61 20 | 66 72 61 6d 65 2c 0d 74 | of a |frame,.t|
|00000a20| 68 65 6e 2c 20 20 77 6f | 75 6c 64 20 62 65 20 74 |hen, wo|uld be t|
|00000a30| 68 65 20 62 61 63 6b 20 | 20 73 69 64 65 20 6f 66 |he back | side of|
|00000a40| 20 74 68 65 20 70 61 70 | 65 72 2e 20 20 20 57 68 | the pap|er. Wh|
|00000a50| 65 6e 20 79 6f 75 20 70 | 72 65 73 73 20 20 46 4f |en you p|ress FO|
|00000a60| 52 4d 55 4c 41 20 45 44 | 49 54 0d 28 46 32 29 2c |RMULA ED|IT.(F2),|
|00000a70| 20 20 79 6f 75 20 61 72 | 65 20 22 62 65 6e 64 69 | you ar|e "bendi|
|00000a80| 6e 67 20 62 61 63 6b 22 | 20 74 68 65 20 74 6f 70 |ng back"| the top|
|00000a90| 20 6f 66 20 74 68 65 20 | 70 61 67 65 20 74 6f 20 | of the |page to |
|00000aa0| 70 65 65 6b 20 61 74 20 | 6a 75 73 74 20 74 68 65 |peek at |just the|
|00000ab0| 20 66 69 72 73 74 0d 6c | 69 6e 65 20 6f 6e 20 74 | first.l|ine on t|
|00000ac0| 68 65 20 62 61 63 6b 20 | 6f 66 20 79 6f 75 72 20 |he back |of your |
|00000ad0| 73 68 65 65 74 2e 20 20 | 4c 69 6b 65 77 69 73 65 |sheet. |Likewise|
|00000ae0| 2c 20 77 68 65 6e 20 79 | 6f 75 20 70 72 65 73 73 |, when y|ou press|
|00000af0| 20 46 4f 52 4d 55 4c 41 | 20 45 44 49 54 20 28 46 | FORMULA| EDIT (F|
|00000b00| 32 29 0d 61 6e 64 20 74 | 68 65 6e 20 5a 4f 4f 4d |2).and t|hen ZOOM|
|00000b10| 20 28 46 39 29 2c 20 69 | 74 27 73 20 6c 69 6b 65 | (F9), i|t's like|
|00000b20| 20 66 6c 69 70 70 69 6e | 67 20 74 68 65 20 77 68 | flippin|g the wh|
|00000b30| 6f 6c 65 20 73 68 65 65 | 74 20 6f 76 65 72 20 73 |ole shee|t over s|
|00000b40| 6f 20 79 6f 75 20 63 61 | 6e 20 76 69 65 77 0d 74 |o you ca|n view.t|
|00000b50| 68 65 20 77 68 6f 6c 65 | 20 62 61 63 6b 73 69 64 |he whole| backsid|
|00000b60| 65 2e 20 20 54 68 65 20 | 66 72 6f 6e 74 20 6f 66 |e. The |front of|
|00000b70| 20 61 20 66 72 61 6d 65 | 20 69 73 20 63 61 6c 6c | a frame| is call|
|00000b80| 65 64 20 74 68 65 20 22 | 63 6f 6e 74 65 6e 74 73 |ed the "|contents|
|00000b90| 2c 22 20 61 6e 64 20 74 | 68 65 0d 62 61 63 6b 73 |," and t|he.backs|
|00000ba0| 69 64 65 20 69 73 20 63 | 61 6c 6c 65 64 20 20 74 |ide is c|alled t|
|00000bb0| 68 65 20 22 66 6f 72 6d | 75 6c 61 22 20 20 6f 72 |he "form|ula" or|
|00000bc0| 20 22 66 6f 72 6d 75 6c | 61 20 73 70 61 63 65 2e | "formul|a space.|
|00000bd0| 22 20 20 48 6f 70 65 66 | 75 6c 6c 79 2c 20 79 6f |" Hopef|ully, yo|
|00000be0| 75 20 68 61 76 65 0d 68 | 61 64 20 61 20 63 68 61 |u have.h|ad a cha|
|00000bf0| 6e 63 65 20 74 6f 20 77 | 6f 72 6b 20 20 77 69 74 |nce to w|ork wit|
|00000c00| 68 20 74 68 65 20 63 6f | 6e 74 65 6e 74 73 20 70 |h the co|ntents p|
|00000c10| 6f 72 74 69 6f 6e 20 6f | 66 20 20 74 68 65 20 64 |ortion o|f the d|
|00000c20| 69 66 66 65 72 65 6e 74 | 20 20 74 79 70 65 73 20 |ifferent| types |
|00000c30| 6f 66 0d 66 72 61 6d 65 | 73 2c 20 20 73 6f 20 77 |of.frame|s, so w|
|00000c40| 65 20 20 77 69 6c 6c 20 | 63 6f 6e 63 65 6e 74 72 |e will |concentr|
|00000c50| 61 74 65 20 20 6f 6e 20 | 68 6f 77 20 74 6f 20 75 |ate on |how to u|
|00000c60| 73 65 20 74 68 65 20 66 | 6f 72 6d 75 6c 61 20 20 |se the f|ormula |
|00000c70| 73 70 61 63 65 20 20 74 | 6f 20 6d 61 6b 65 0d 46 |space t|o make.F|
|00000c80| 72 61 6d 65 77 6f 72 6b | 20 73 69 74 20 75 70 20 |ramework| sit up |
|00000c90| 61 6e 64 20 74 61 6b 65 | 20 6e 6f 74 69 63 65 20 |and take| notice |
|00000ca0| 6f 66 20 79 6f 75 72 20 | 73 70 65 63 69 61 6c 20 |of your |special |
|00000cb0| 6e 65 65 64 73 2e ff 02 | 00 4b 20 ff 02 00 4b 54 |needs...|.K ...KT|
|00000cc0| 68 65 20 66 69 72 73 74 | 20 70 6c 61 63 65 20 61 |he first| place a|
|00000cd0| 6e 79 6f 6e 65 20 20 74 | 68 69 6e 6b 73 20 20 6f |nyone t|hinks o|
|00000ce0| 66 20 20 75 73 69 6e 67 | 20 74 68 65 20 20 66 6f |f using| the fo|
|00000cf0| 72 6d 75 6c 61 73 20 20 | 6f 66 20 20 46 52 45 44 |rmulas |of FRED|
|00000d00| 20 20 69 73 20 20 69 6e | 20 61 0d 73 70 72 65 61 | is in| a.sprea|
|00000d10| 64 73 68 65 65 74 2c 20 | 20 6e 61 74 75 72 61 6c |dsheet, | natural|
|00000d20| 6c 79 2c 20 20 62 65 63 | 61 75 73 65 20 46 52 45 |ly, bec|ause FRE|
|00000d30| 44 20 69 73 20 76 65 72 | 79 20 73 69 6d 69 6c 61 |D is ver|y simila|
|00000d40| 72 20 74 6f 20 74 68 65 | 20 66 6f 72 6d 75 6c 61 |r to the| formula|
|00000d50| 73 20 75 73 65 64 0d 69 | 6e 20 20 63 6f 6e 76 65 |s used.i|n conve|
|00000d60| 6e 74 69 6f 6e 61 6c 20 | 20 73 70 72 65 61 64 73 |ntional | spreads|
|00000d70| 68 65 65 74 73 2c 20 20 | 61 6e 64 20 20 62 65 63 |heets, |and bec|
|00000d80| 61 75 73 65 20 74 68 65 | 20 67 6f 61 6c 20 20 6f |ause the| goal o|
|00000d90| 66 20 20 73 70 72 65 61 | 64 73 68 65 65 74 73 20 |f sprea|dsheets |
|00000da0| 69 6e 0d 67 65 6e 65 72 | 61 6c 20 69 73 20 74 6f |in.gener|al is to|
|00000db0| 20 20 6d 61 6b 65 20 63 | 61 6c 63 75 6c 61 74 69 | make c|alculati|
|00000dc0| 6f 6e 73 20 65 61 73 79 | 2e 20 20 20 42 75 74 20 |ons easy|. But |
|00000dd0| 46 72 61 6d 65 77 6f 72 | 6b 20 61 6c 6c 6f 77 73 |Framewor|k allows|
|00000de0| 20 20 61 6e 79 20 66 72 | 61 6d 65 20 74 6f 0d 68 | any fr|ame to.h|
|00000df0| 61 76 65 20 61 20 66 6f | 72 6d 75 6c 61 20 62 65 |ave a fo|rmula be|
|00000e00| 68 69 6e 64 20 20 69 74 | 2e 20 20 20 49 6e 20 20 |hind it|. In |
|00000e10| 61 20 77 61 79 2c 20 20 | 79 6f 75 20 63 61 6e 20 |a way, |you can |
|00000e20| 20 74 68 69 6e 6b 20 20 | 6f 66 20 20 66 72 61 6d | think |of fram|
|00000e30| 65 73 20 20 61 73 20 62 | 69 67 0d 73 70 72 65 61 |es as b|ig.sprea|
|00000e40| 64 73 68 65 65 74 20 63 | 65 6c 6c 73 2c 20 6f 72 |dsheet c|ells, or|
|00000e50| 20 74 68 69 6e 6b 20 6f | 66 20 65 61 63 68 20 63 | think o|f each c|
|00000e60| 65 6c 6c 20 61 73 20 62 | 65 69 6e 67 20 61 20 66 |ell as b|eing a f|
|00000e70| 72 61 6d 65 2e 20 20 54 | 68 69 73 20 6d 65 61 6e |rame. T|his mean|
|00000e80| 73 20 74 68 61 74 0d 61 | 20 46 52 45 44 20 70 72 |s that.a| FRED pr|
|00000e90| 6f 67 72 61 6d 20 20 6f | 66 20 75 70 20 74 6f 20 |ogram o|f up to |
|00000ea0| 20 33 32 2c 30 30 30 20 | 20 63 68 61 72 61 63 74 | 32,000 | charact|
|00000eb0| 65 72 73 20 63 61 6e 20 | 62 65 20 73 74 6f 72 65 |ers can |be store|
|00000ec0| 64 20 69 6e 20 61 6e 79 | 20 20 6f 66 20 74 68 6f |d in any| of tho|
|00000ed0| 73 65 0d 66 6f 72 6d 75 | 6c 61 20 73 70 61 63 65 |se.formu|la space|
|00000ee0| 73 2e 20 20 20 54 68 65 | 20 6f 6e 6c 79 20 70 72 |s. The| only pr|
|00000ef0| 61 63 74 69 63 61 6c 20 | 6c 69 6d 69 74 61 74 69 |actical |limitati|
|00000f00| 6f 6e 20 6f 6e 20 74 68 | 69 73 20 69 73 20 74 68 |on on th|is is th|
|00000f10| 61 74 20 74 68 65 20 66 | 6f 72 6d 75 6c 61 0d 73 |at the f|ormula.s|
|00000f20| 70 61 63 65 20 62 65 68 | 69 6e 64 20 20 61 20 64 |pace beh|ind a d|
|00000f30| 61 74 61 62 61 73 65 20 | 20 66 72 61 6d 65 20 69 |atabase | frame i|
|00000f40| 73 20 20 73 70 65 63 69 | 61 6c 2c 20 20 61 6e 64 |s speci|al, and|
|00000f50| 20 69 73 20 20 75 73 65 | 64 20 20 74 6f 20 22 66 | is use|d to "f|
|00000f60| 69 6c 74 65 72 22 20 74 | 68 65 0d 72 65 63 6f 72 |ilter" t|he.recor|
|00000f70| 64 73 20 74 6f 20 20 61 | 20 73 65 6c 65 63 74 20 |ds to a| select |
|00000f80| 20 67 72 6f 75 70 20 20 | 28 73 65 65 20 20 70 61 | group |(see pa|
|00000f90| 67 65 20 20 38 2d 31 36 | 20 20 6f 66 20 20 74 68 |ge 8-16| of th|
|00000fa0| 65 20 20 46 72 61 6d 65 | 77 6f 72 6b 20 52 65 66 |e Frame|work Ref|
|00000fb0| 65 72 65 6e 63 65 0d 4d | 61 6e 75 61 6c 29 2e 20 |erence.M|anual). |
|00000fc0| 20 20 57 68 65 72 65 61 | 73 20 74 68 61 74 20 66 | Wherea|s that f|
|00000fd0| 6f 72 6d 75 6c 61 20 63 | 6f 75 6c 64 20 62 65 20 |ormula c|ould be |
|00000fe0| 76 65 72 79 20 6c 61 72 | 67 65 2c 20 20 69 74 20 |very lar|ge, it |
|00000ff0| 69 73 20 61 20 67 6f 6f | 64 20 20 69 64 65 61 20 |is a goo|d idea |
|00001000| 74 6f 0d 6b 65 65 70 20 | 69 6d 70 6f 72 74 61 6e |to.keep |importan|
|00001010| 74 20 63 6f 6e 74 72 6f | 6c 20 70 72 6f 67 72 61 |t contro|l progra|
|00001020| 6d 73 20 69 6e 20 73 6f | 6d 65 20 6f 74 68 65 72 |ms in so|me other|
|00001030| 20 74 79 70 65 20 6f 66 | 20 66 72 61 6d 65 2e ff | type of| frame..|
|00001040| 02 00 4b 20 ff 02 00 4b | 00 04 47 65 74 74 69 6e |..K ...K|..Gettin|
|00001050| 67 20 53 74 61 72 74 65 | 64 ff 02 00 4b ff 02 00 |g Starte|d...K...|
|00001060| 4b 00 00 57 68 61 74 20 | 69 73 20 61 20 70 72 6f |K..What |is a pro|
|00001070| 67 72 61 6d 20 61 6e 79 | 77 61 79 3f 20 20 20 49 |gram any|way? I|
|00001080| 6e 20 20 46 52 45 44 2c | 20 20 61 20 70 72 6f 67 |n FRED,| a prog|
|00001090| 72 61 6d 20 69 73 20 61 | 20 63 6f 6c 6c 65 63 74 |ram is a| collect|
|000010a0| 69 6f 6e 20 20 6f 66 20 | 6f 6e 65 20 6f 72 0d 6d |ion of |one or.m|
|000010b0| 6f 72 65 20 66 75 6e 63 | 74 69 6f 6e 73 2c 20 20 |ore func|tions, |
|000010c0| 73 65 70 61 72 61 74 65 | 64 20 62 79 20 63 6f 6d |separate|d by com|
|000010d0| 6d 61 73 2c 20 20 77 68 | 69 63 68 20 61 72 65 20 |mas, wh|ich are |
|000010e0| 65 76 61 6c 75 61 74 65 | 64 20 6f 6e 65 20 61 74 |evaluate|d one at|
|000010f0| 20 61 20 74 69 6d 65 20 | 74 6f 0d 70 72 6f 64 75 | a time |to.produ|
|00001100| 63 65 20 61 20 64 65 73 | 69 72 65 64 20 72 65 73 |ce a des|ired res|
|00001110| 75 6c 74 2e 20 20 20 41 | 73 20 6f 75 72 20 66 69 |ult. A|s our fi|
|00001120| 72 73 74 20 65 78 61 6d | 70 6c 65 2c 20 77 65 20 |rst exam|ple, we |
|00001130| 77 69 6c 6c 20 74 61 6b | 65 20 74 68 65 20 73 69 |will tak|e the si|
|00001140| 6d 70 6c 65 73 74 0d 63 | 61 73 65 3a 20 20 61 20 |mplest.c|ase: a |
|00001150| 73 69 6e 67 6c 65 20 66 | 75 6e 63 74 69 6f 6e 20 |single f|unction |
|00001160| 62 65 68 69 6e 64 20 61 | 6e 20 20 45 6d 70 74 79 |behind a|n Empty|
|00001170| 2f 57 6f 72 64 20 46 72 | 61 6d 65 2e 20 20 20 53 |/Word Fr|ame. S|
|00001180| 74 61 72 74 20 77 69 74 | 68 20 61 6e 20 65 6d 70 |tart wit|h an emp|
|00001190| 74 79 0d 64 65 73 6b 74 | 6f 70 2c 20 20 61 6e 64 |ty.deskt|op, and|
|000011a0| 20 43 72 65 61 74 65 20 | 20 61 6e 20 20 45 6d 70 | Create | an Emp|
|000011b0| 74 79 2f 57 6f 72 64 20 | 20 46 72 61 6d 65 2e 20 |ty/Word | Frame. |
|000011c0| 20 20 54 69 74 6c 65 20 | 69 74 20 4d 65 6d 6f 72 | Title |it Memor|
|000011d0| 79 2e 20 20 20 4e 6f 77 | 20 70 72 65 73 73 0d 46 |y. Now| press.F|
|000011e0| 4f 52 4d 55 4c 41 20 45 | 44 49 54 20 28 46 32 29 |ORMULA E|DIT (F2)|
|000011f0| 2c 20 61 6e 64 20 79 6f | 75 20 73 65 65 20 74 68 |, and yo|u see th|
|00001200| 65 20 63 75 72 73 6f 72 | 20 6f 6e 20 74 68 65 20 |e cursor| on the |
|00001210| 65 64 69 74 20 6c 69 6e | 65 2c 20 61 6e 64 20 61 |edit lin|e, and a|
|00001220| 20 70 72 6f 6d 70 74 20 | 61 74 0d 74 68 65 20 20 | prompt |at.the |
|00001230| 62 6f 74 74 6f 6d 20 20 | 6f 66 20 20 74 68 65 20 |bottom |of the |
|00001240| 20 73 63 72 65 65 6e 20 | 20 74 68 61 74 20 20 73 | screen | that s|
|00001250| 61 79 73 2c 20 20 22 46 | 6f 72 6d 75 6c 61 2f 6e |ays, "F|ormula/n|
|00001260| 75 6d 62 65 72 20 20 65 | 64 69 74 69 6e 67 3b 20 |umber e|diting; |
|00001270| 52 45 54 55 52 4e 0d 66 | 69 6e 69 73 68 65 73 2e |RETURN.f|inishes.|
|00001280| 22 20 54 79 70 65 20 40 | 6d 65 6d 61 76 61 69 6c |" Type @|memavail|
|00001290| 20 61 6e 64 20 70 72 65 | 73 73 20 52 65 74 75 72 | and pre|ss Retur|
|000012a0| 6e 2e 20 20 4e 6f 74 69 | 63 65 20 74 68 61 74 20 |n. Noti|ce that |
|000012b0| 74 68 65 20 66 72 61 6d | 65 20 63 6f 6e 74 65 6e |the fram|e conten|
|000012c0| 74 73 0d 6e 6f 77 20 68 | 61 73 20 61 20 6e 75 6d |ts.now h|as a num|
|000012d0| 62 65 72 20 20 69 6e 20 | 20 69 74 2e 20 20 20 54 |ber in | it. T|
|000012e0| 68 69 73 20 69 73 20 74 | 68 65 20 72 65 73 75 6c |his is t|he resul|
|000012f0| 74 20 20 6f 66 20 20 6f | 75 72 20 73 69 6d 70 6c |t of o|ur simpl|
|00001300| 65 20 6f 6e 65 2d 66 75 | 6e 63 74 69 6f 6e 0d 70 |e one-fu|nction.p|
|00001310| 72 6f 67 72 61 6d 2e 20 | 20 54 68 65 20 66 75 6e |rogram. | The fun|
|00001320| 63 74 69 6f 6e 20 79 6f | 75 20 74 79 70 65 64 20 |ction yo|u typed |
|00001330| 69 6e 2c 20 40 6d 65 6d | 61 76 61 69 6c 2c 20 72 |in, @mem|avail, r|
|00001340| 65 74 75 72 6e 73 20 74 | 68 65 20 6e 75 6d 62 65 |eturns t|he numbe|
|00001350| 72 20 6f 66 20 62 79 74 | 65 73 0d 6f 66 20 6d 65 |r of byt|es.of me|
|00001360| 6d 6f 72 79 20 72 65 6d | 61 69 6e 69 6e 67 20 6f |mory rem|aining o|
|00001370| 6e 20 79 6f 75 72 20 64 | 65 73 6b 74 6f 70 2e ff |n your d|esktop..|
|00001380| 02 00 4b 20 ff 02 00 4b | 54 68 69 73 20 69 73 20 |..K ...K|This is |
|00001390| 61 20 67 6f 6f 64 20 74 | 69 6d 65 20 20 74 6f 20 |a good t|ime to |
|000013a0| 64 69 73 63 75 73 73 20 | 20 61 6e 20 69 6d 70 6f |discuss | an impo|
|000013b0| 72 74 61 6e 74 20 63 6f | 6e 63 65 70 74 20 20 69 |rtant co|ncept i|
|000013c0| 6e 20 46 52 45 44 20 70 | 72 6f 67 72 61 6d 6d 69 |n FRED p|rogrammi|
|000013d0| 6e 67 3a 0d 65 76 65 72 | 79 20 66 75 6e 63 74 69 |ng:.ever|y functi|
|000013e0| 6f 6e 20 72 65 74 75 72 | 6e 73 20 61 20 76 61 6c |on retur|ns a val|
|000013f0| 75 65 2e 20 20 20 45 76 | 65 6e 20 69 66 20 20 74 |ue. Ev|en if t|
|00001400| 68 65 20 66 75 6e 63 74 | 69 6f 6e 20 64 6f 65 73 |he funct|ion does|
|00001410| 20 6e 6f 74 20 20 70 65 | 72 66 6f 72 6d 20 61 0d | not pe|rform a.|
|00001420| 63 61 6c 63 75 6c 61 74 | 69 6f 6e 20 69 74 20 73 |calculat|ion it s|
|00001430| 74 69 6c 6c 20 72 65 74 | 75 72 6e 73 20 73 6f 6d |till ret|urns som|
|00001440| 65 20 20 6b 69 6e 64 20 | 6f 66 20 76 61 6c 75 65 |e kind |of value|
|00001450| 2e 20 20 20 57 68 61 74 | 20 67 6f 6f 64 20 20 69 |. What| good i|
|00001460| 73 20 74 68 61 74 2c 20 | 79 6f 75 0d 61 73 6b 3f |s that, |you.ask?|
|00001470| 20 20 20 57 65 6c 6c 2c | 20 20 69 74 20 6d 65 61 | Well,| it mea|
|00001480| 6e 73 20 74 68 61 74 20 | 61 6e 79 20 66 75 6e 63 |ns that |any func|
|00001490| 74 69 6f 6e 20 63 61 6e | 20 62 65 20 20 75 73 65 |tion can| be use|
|000014a0| 64 20 74 6f 20 72 65 74 | 75 72 6e 20 20 61 20 76 |d to ret|urn a v|
|000014b0| 61 6c 75 65 20 74 6f 0d | 73 6f 6d 65 20 6f 74 68 |alue to.|some oth|
|000014c0| 65 72 20 66 75 6e 63 74 | 69 6f 6e 2c 20 20 61 6c |er funct|ion, al|
|000014d0| 6c 6f 77 69 6e 67 20 61 | 20 70 72 6f 67 72 61 6d |lowing a| program|
|000014e0| 6d 65 72 20 74 6f 20 76 | 65 72 79 20 65 61 73 69 |mer to v|ery easi|
|000014f0| 6c 79 20 74 65 73 74 20 | 20 74 68 65 20 72 65 73 |ly test | the res|
|00001500| 75 6c 74 0d 66 72 6f 6d | 20 61 6e 79 20 66 75 6e |ult.from| any fun|
|00001510| 63 74 69 6f 6e 20 68 65 | 20 68 61 73 20 75 73 65 |ction he| has use|
|00001520| 64 2e ff 02 00 4b 20 ff | 02 00 4b 4e 6f 77 20 6c |d....K .|..KNow l|
|00001530| 65 74 27 73 20 63 6f 6e | 73 69 64 65 72 20 68 6f |et's con|sider ho|
|00001540| 77 20 74 6f 20 69 6d 70 | 72 6f 76 65 20 6f 75 72 |w to imp|rove our|
|00001550| 20 73 69 6d 70 6c 69 73 | 74 69 63 20 65 78 61 6d | simplis|tic exam|
|00001560| 70 6c 65 2e 20 20 49 74 | 20 6d 69 67 68 74 20 62 |ple. It| might b|
|00001570| 65 20 6e 69 63 65 0d 74 | 6f 20 68 61 76 65 20 74 |e nice.t|o have t|
|00001580| 68 65 20 72 65 73 75 6c | 74 20 28 76 61 6c 75 65 |he resul|t (value|
|00001590| 29 20 20 6f 66 20 74 68 | 65 20 70 72 6f 67 72 61 |) of th|e progra|
|000015a0| 6d 20 61 70 70 65 61 72 | 20 6f 6e 20 74 68 65 20 |m appear| on the |
|000015b0| 70 72 6f 6d 70 74 20 6c | 69 6e 65 20 61 74 20 74 |prompt l|ine at t|
|000015c0| 68 65 0d 62 6f 74 74 6f | 6d 20 20 6f 66 20 20 74 |he.botto|m of t|
|000015d0| 68 65 20 73 63 72 65 65 | 6e 2c 20 20 66 6f 72 6d |he scree|n, form|
|000015e0| 61 74 74 65 64 20 77 69 | 74 68 20 63 6f 6d 6d 61 |atted wi|th comma|
|000015f0| 73 2c 20 20 61 6e 64 20 | 6d 61 79 62 65 20 20 65 |s, and |maybe e|
|00001600| 76 65 6e 20 61 20 66 72 | 69 65 6e 64 6c 79 0d 6d |ven a fr|iendly.m|
|00001610| 65 73 73 61 67 65 20 6c | 69 6b 65 20 22 59 6f 75 |essage l|ike "You|
|00001620| 20 68 61 76 65 20 32 33 | 2c 34 35 36 20 20 62 79 | have 23|,456 by|
|00001630| 74 65 73 20 72 65 6d 61 | 69 6e 69 6e 67 20 6f 6e |tes rema|ining on|
|00001640| 20 74 68 65 20 64 65 73 | 6b 74 6f 70 22 2e 20 20 | the des|ktop". |
|00001650| 48 65 72 65 27 73 20 74 | 68 65 0d 70 72 6f 67 72 |Here's t|he.progr|
|00001660| 61 6d 3a ff 02 00 4b 20 | ff 02 00 4b 20 ff 02 00 |am:...K |...K ...|
|00001670| 4b 3b 20 53 68 6f 77 20 | 6d 65 6d 6f 72 79 20 72 |K; Show |memory r|
|00001680| 65 6d 61 69 6e 69 6e 67 | 2e ff 02 00 4b 40 65 72 |emaining|....K@er|
|00001690| 61 73 65 70 72 6f 6d 70 | 74 2c ff 02 00 4b 40 70 |asepromp|t,...K@p|
|000016a0| 72 6f 6d 70 74 28 20 22 | 59 6f 75 20 68 61 76 65 |rompt( "|You have|
|000016b0| 20 22 20 26 ff 02 00 4b | 20 20 20 20 20 20 20 20 | " &...K| |
|000016c0| 20 40 62 75 73 69 6e 65 | 73 73 28 20 40 6d 65 6d | @busine|ss( @mem|
|000016d0| 61 76 61 69 6c 2c 30 20 | 29 20 26 ff 02 00 4b 20 |avail,0 |) &...K |
|000016e0| 20 20 20 20 20 20 20 20 | 22 20 62 79 74 65 73 20 | |" bytes |
|000016f0| 72 65 6d 61 69 6e 69 6e | 67 20 66 6f 72 20 74 68 |remainin|g for th|
|00001700| 65 20 64 65 73 6b 74 6f | 70 2e 22 20 29 ff 02 00 |e deskto|p." )...|
|00001710| 4b 20 ff 02 00 4b 54 6f | 20 65 6e 74 65 72 20 74 |K ...KTo| enter t|
|00001720| 68 65 20 70 72 6f 67 72 | 61 6d 2c 20 68 69 67 68 |he progr|am, high|
|00001730| 6c 69 67 68 74 20 74 68 | 65 20 73 61 6d 65 20 66 |light th|e same f|
|00001740| 72 61 6d 65 20 79 6f 75 | 20 75 73 65 64 20 62 65 |rame you| used be|
|00001750| 66 6f 72 65 2c 20 4d 65 | 6d 6f 72 79 2c 20 61 6e |fore, Me|mory, an|
|00001760| 64 0d 70 72 65 73 73 20 | 46 4f 52 4d 55 4c 41 20 |d.press |FORMULA |
|00001770| 45 44 49 54 20 28 46 32 | 29 20 20 61 6e 64 20 5a |EDIT (F2|) and Z|
|00001780| 4f 4f 4d 20 28 46 39 29 | 20 74 6f 20 77 6f 72 6b |OOM (F9)| to work|
|00001790| 20 77 69 74 68 20 74 68 | 65 20 77 68 6f 6c 65 20 | with th|e whole |
|000017a0| 66 6f 72 6d 75 6c 61 20 | 73 70 61 63 65 0d 28 74 |formula |space.(t|
|000017b0| 68 65 20 62 61 63 6b 73 | 69 64 65 20 6f 66 20 74 |he backs|ide of t|
|000017c0| 68 65 20 66 72 61 6d 65 | 2c 20 20 72 65 6d 65 6d |he frame|, remem|
|000017d0| 62 65 72 3f 29 2c 20 20 | 74 68 65 6e 20 43 74 72 |ber?), |then Ctr|
|000017e0| 6c 2d 50 67 44 6e 20 61 | 6e 64 20 44 65 6c 20 20 |l-PgDn a|nd Del |
|000017f0| 74 6f 20 64 65 6c 65 74 | 65 0d 74 68 65 20 6f 6c |to delet|e.the ol|
|00001800| 64 20 66 6f 72 6d 75 6c | 61 2e ff 02 00 4b ff 02 |d formul|a....K..|
|00001810| 00 4b 54 79 70 65 20 69 | 6e 20 74 68 65 20 6e 65 |.KType i|n the ne|
|00001820| 77 20 70 72 6f 67 72 61 | 6d 2c 20 20 61 6e 64 20 |w progra|m, and |
|00001830| 70 72 65 73 73 20 45 73 | 63 20 77 68 65 6e 20 64 |press Es|c when d|
|00001840| 6f 6e 65 2e 20 20 20 41 | 6e 79 20 74 69 6d 65 20 |one. A|ny time |
|00001850| 79 6f 75 20 68 69 67 68 | 6c 69 67 68 74 0d 74 68 |you high|light.th|
|00001860| 65 20 66 72 61 6d 65 20 | 62 6f 72 64 65 72 20 61 |e frame |border a|
|00001870| 6e 64 20 52 45 43 41 4c | 43 20 28 46 35 29 2c 20 |nd RECAL|C (F5), |
|00001880| 20 79 6f 75 20 77 69 6c | 6c 20 73 65 65 20 61 20 | you wil|l see a |
|00001890| 6d 65 73 73 61 67 65 20 | 61 74 20 74 68 65 20 20 |message |at the |
|000018a0| 62 6f 74 74 6f 6d 20 6f | 66 0d 74 68 65 20 73 63 |bottom o|f.the sc|
|000018b0| 72 65 65 6e 20 64 69 73 | 70 6c 61 79 69 6e 67 20 |reen dis|playing |
|000018c0| 68 6f 77 20 20 6d 75 63 | 68 20 6d 65 6d 6f 72 79 |how muc|h memory|
|000018d0| 20 79 6f 75 20 68 61 76 | 65 3b 20 20 61 6e 64 20 | you hav|e; and |
|000018e0| 69 74 20 64 6f 65 73 6e | 27 74 20 20 6d 61 74 74 |it doesn|'t matt|
|000018f0| 65 72 20 69 66 0d 74 68 | 65 20 66 72 61 6d 65 20 |er if.th|e frame |
|00001900| 69 73 20 6f 70 65 6e 20 | 6f 72 20 63 6c 6f 73 65 |is open |or close|
|00001910| 64 2e 20 20 54 68 65 20 | 66 69 72 73 74 20 74 68 |d. The |first th|
|00001920| 69 6e 67 20 74 68 65 20 | 70 72 6f 67 72 61 6d 20 |ing the |program |
|00001930| 64 6f 65 73 20 69 73 20 | 65 72 61 73 65 20 74 68 |does is |erase th|
|00001940| 65 0d 70 72 6f 6d 70 74 | 20 6c 69 6e 65 20 28 61 |e.prompt| line (a|
|00001950| 6c 77 61 79 73 20 20 61 | 20 67 6f 6f 64 20 70 72 |lways a| good pr|
|00001960| 61 63 74 69 63 65 29 2c | 20 20 74 68 65 6e 20 69 |actice),| then i|
|00001970| 74 20 64 69 73 70 6c 61 | 79 73 20 61 20 20 70 72 |t displa|ys a pr|
|00001980| 6f 6d 70 74 2e 20 20 4e | 6f 74 69 63 65 0d 74 68 |ompt. N|otice.th|
|00001990| 61 74 20 74 68 65 72 65 | 20 61 72 65 20 6f 6e 6c |at there| are onl|
|000019a0| 79 20 20 74 77 6f 20 6d | 61 69 6e 20 20 66 75 6e |y two m|ain fun|
|000019b0| 63 74 69 6f 6e 73 20 74 | 6f 20 20 74 68 65 20 70 |ctions t|o the p|
|000019c0| 72 6f 67 72 61 6d 2c 20 | 20 40 65 72 61 73 65 70 |rogram, | @erasep|
|000019d0| 72 6f 6d 70 74 20 61 6e | 64 0d 40 70 72 6f 6d 70 |rompt an|d.@promp|
|000019e0| 74 2c 20 20 73 6f 20 74 | 68 65 72 65 20 6d 75 73 |t, so t|here mus|
|000019f0| 74 20 62 65 20 61 20 63 | 6f 6d 6d 61 20 62 65 74 |t be a c|omma bet|
|00001a00| 77 65 65 6e 20 74 68 65 | 20 66 75 6e 63 74 69 6f |ween the| functio|
|00001a10| 6e 73 2c 20 62 75 74 20 | 6e 6f 74 20 61 66 74 65 |ns, but |not afte|
|00001a20| 72 20 74 68 65 0d 6c 61 | 73 74 20 6f 6e 65 2e 20 |r the.la|st one. |
|00001a30| 20 20 41 6c 6c 20 74 68 | 65 20 40 70 72 6f 6d 70 | All th|e @promp|
|00001a40| 74 20 66 75 6e 63 74 69 | 6f 6e 20 64 6f 65 73 20 |t functi|on does |
|00001a50| 69 73 20 70 72 69 6e 74 | 20 61 20 73 74 72 69 6e |is print| a strin|
|00001a60| 67 20 20 6f 6e 20 20 74 | 68 65 20 70 72 6f 6d 70 |g on t|he promp|
|00001a70| 74 0d 6c 69 6e 65 2c 20 | 20 62 75 74 20 62 65 66 |t.line, | but bef|
|00001a80| 6f 72 65 20 20 69 74 20 | 20 63 61 6e 20 64 6f 20 |ore it | can do |
|00001a90| 20 74 68 61 74 20 20 77 | 69 74 68 20 20 6f 75 72 | that w|ith our|
|00001aa0| 20 20 70 72 6f 6d 70 74 | 2c 20 20 74 68 65 20 20 | prompt|, the |
|00001ab0| 40 62 75 73 69 6e 65 73 | 73 20 61 6e 64 0d 40 6d |@busines|s and.@m|
|00001ac0| 65 6d 61 76 61 69 6c 20 | 20 66 75 6e 63 74 69 6f |emavail | functio|
|00001ad0| 6e 73 20 20 68 61 76 65 | 20 20 74 6f 20 20 62 65 |ns have| to be|
|00001ae0| 20 20 65 76 61 6c 75 61 | 74 65 64 2e 20 20 20 46 | evalua|ted. F|
|00001af0| 52 45 44 20 20 73 74 61 | 72 74 73 20 20 65 76 61 |RED sta|rts eva|
|00001b00| 6c 75 61 74 69 6e 67 20 | 61 0d 66 75 6e 63 74 69 |luating |a.functi|
|00001b10| 6f 6e 20 61 74 20 74 68 | 65 20 69 6e 6e 65 72 6d |on at th|e innerm|
|00001b20| 6f 73 74 20 70 61 72 65 | 6e 74 68 65 73 65 73 20 |ost pare|ntheses |
|00001b30| 73 6f 20 74 68 61 74 20 | 69 74 20 63 61 6e 20 70 |so that |it can p|
|00001b40| 61 73 73 20 74 68 65 20 | 72 65 73 75 6c 74 20 74 |ass the |result t|
|00001b50| 6f 20 74 68 65 0d 73 75 | 72 72 6f 75 6e 64 69 6e |o the.su|rroundin|
|00001b60| 67 20 66 75 6e 63 74 69 | 6f 6e 2e 20 20 20 49 6e |g functi|on. In|
|00001b70| 20 74 68 69 73 20 63 61 | 73 65 2c 20 46 52 45 44 | this ca|se, FRED|
|00001b80| 20 62 65 67 69 6e 73 20 | 77 69 74 68 20 40 6d 65 | begins |with @me|
|00001b90| 6d 61 76 61 69 6c 2c 20 | 74 61 6b 65 73 20 74 68 |mavail, |takes th|
|00001ba0| 65 0d 72 65 73 75 6c 74 | 20 28 61 20 6e 75 6d 62 |e.result| (a numb|
|00001bb0| 65 72 29 20 20 61 6e 64 | 20 75 73 65 73 20 69 74 |er) and| uses it|
|00001bc0| 20 69 6e 20 40 62 75 73 | 69 6e 65 73 73 2c 20 77 | in @bus|iness, w|
|00001bd0| 68 69 63 68 20 63 6f 6e | 76 65 72 74 73 20 74 68 |hich con|verts th|
|00001be0| 65 20 6e 75 6d 62 65 72 | 20 74 6f 20 61 0d 73 74 |e number| to a.st|
|00001bf0| 72 69 6e 67 20 61 6e 64 | 20 66 6f 72 6d 61 74 73 |ring and| formats|
|00001c00| 20 69 74 20 20 77 69 74 | 68 20 63 6f 6d 6d 61 73 | it wit|h commas|
|00001c10| 2e 20 20 20 54 68 65 20 | 61 6d 70 65 72 73 61 6e |. The |ampersan|
|00001c20| 64 20 28 26 29 20 20 63 | 68 61 72 61 63 74 65 72 |d (&) c|haracter|
|00001c30| 73 20 79 6f 75 20 73 65 | 65 0d 61 72 65 20 75 73 |s you se|e.are us|
|00001c40| 65 64 20 74 6f 20 73 74 | 69 63 6b 20 73 74 72 69 |ed to st|ick stri|
|00001c50| 6e 67 73 20 74 6f 67 65 | 74 68 65 72 2e 20 20 20 |ngs toge|ther. |
|00001c60| 46 6f 72 20 69 6e 73 74 | 61 6e 63 65 2c 20 20 74 |For inst|ance, t|
|00001c70| 68 65 20 73 74 72 69 6e | 67 20 22 59 6f 75 20 68 |he strin|g "You h|
|00001c80| 61 76 65 20 22 0d 68 61 | 73 20 20 74 68 65 20 73 |ave ".ha|s the s|
|00001c90| 74 72 69 6e 67 20 20 66 | 72 6f 6d 20 20 40 62 75 |tring f|rom @bu|
|00001ca0| 73 69 6e 65 73 73 20 20 | 63 6f 6e 63 61 74 65 6e |siness |concaten|
|00001cb0| 61 74 65 64 20 20 74 6f | 20 20 69 74 2c 20 20 61 |ated to| it, a|
|00001cc0| 6e 64 20 20 74 68 65 6e | 20 20 22 20 62 79 74 65 |nd then| " byte|
|00001cd0| 73 0d 72 65 6d 61 69 6e | 69 6e 67 20 6f 6e 20 74 |s.remain|ing on t|
|00001ce0| 68 65 20 64 65 73 6b 74 | 6f 70 22 20 20 69 73 20 |he deskt|op" is |
|00001cf0| 63 6f 6e 63 61 74 65 6e | 61 74 65 64 20 74 6f 20 |concaten|ated to |
|00001d00| 74 68 65 20 65 6e 64 20 | 6f 66 20 74 68 61 74 2e |the end |of that.|
|00001d10| 20 20 20 54 68 69 73 20 | 77 68 6f 6c 65 0d 73 74 | This |whole.st|
|00001d20| 72 69 6e 67 20 69 73 20 | 74 68 65 6e 20 70 61 73 |ring is |then pas|
|00001d30| 73 65 64 20 74 6f 20 40 | 70 72 6f 6d 70 74 20 74 |sed to @|prompt t|
|00001d40| 6f 20 62 65 20 64 69 73 | 70 6c 61 79 65 64 2e 20 |o be dis|played. |
|00001d50| 20 50 72 65 74 74 79 20 | 73 69 6d 70 6c 65 2c 20 | Pretty |simple, |
|00001d60| 69 73 6e 27 74 20 69 74 | 3f ff 02 00 4b 20 ff 02 |isn't it|?...K ..|
|00001d70| 00 4b 20 ff 02 00 4b 00 | 04 53 74 6f 72 69 6e 67 |.K ...K.|.Storing|
|00001d80| 20 59 6f 75 72 20 52 65 | 73 75 6c 74 73 ff 02 00 | Your Re|sults...|
|00001d90| 4b ff 02 00 4b 00 00 4a | 75 73 74 20 66 6f 72 20 |K...K..J|ust for |
|00001da0| 66 75 6e 2c 20 20 6c 65 | 74 27 73 20 73 75 70 70 |fun, le|t's supp|
|00001db0| 6f 73 65 20 74 68 61 74 | 20 79 6f 75 20 77 61 6e |ose that| you wan|
|00001dc0| 74 65 64 20 74 6f 20 73 | 61 76 65 20 20 74 68 61 |ted to s|ave tha|
|00001dd0| 74 20 6d 65 6d 6f 72 79 | 20 72 65 6d 61 69 6e 69 |t memory| remaini|
|00001de0| 6e 67 0d 72 65 73 75 6c | 74 20 73 6f 6d 65 77 68 |ng.resul|t somewh|
|00001df0| 65 72 65 20 73 6f 20 79 | 6f 75 20 63 6f 75 6c 64 |ere so y|ou could|
|00001e00| 20 75 73 65 20 69 74 20 | 6c 61 74 65 72 2e 20 20 | use it |later. |
|00001e10| 20 54 68 65 72 65 27 73 | 20 61 20 6c 6f 74 20 6f | There's| a lot o|
|00001e20| 66 20 20 70 6c 61 63 65 | 73 20 74 68 61 74 0d 63 |f place|s that.c|
|00001e30| 6f 75 6c 64 20 68 6f 6c | 64 20 74 68 61 74 20 76 |ould hol|d that v|
|00001e40| 61 6c 75 65 20 66 6f 72 | 20 79 6f 75 2c 20 20 73 |alue for| you, s|
|00001e50| 6f 20 77 65 27 6c 6c 20 | 74 72 79 20 73 65 76 65 |o we'll |try seve|
|00001e60| 72 61 6c 20 6f 66 20 74 | 68 65 6d 20 74 6f 20 64 |ral of t|hem to d|
|00001e70| 65 6d 6f 6e 73 74 72 61 | 74 65 0d 76 61 72 69 6f |emonstra|te.vario|
|00001e80| 75 73 20 73 74 6f 72 61 | 67 65 20 74 65 63 68 6e |us stora|ge techn|
|00001e90| 69 71 75 65 73 2e 20 20 | 20 59 6f 75 20 73 74 69 |iques. | You sti|
|00001ea0| 6c 6c 20 68 61 76 65 20 | 74 68 65 20 66 72 61 6d |ll have |the fram|
|00001eb0| 65 20 6e 61 6d 65 64 20 | 4d 65 6d 6f 72 79 2c 20 |e named |Memory, |
|00001ec0| 72 69 67 68 74 3f 0d 4f | 4b 2c 20 20 6e 6f 77 20 |right?.O|K, now |
|00001ed0| 63 72 65 61 74 65 20 61 | 20 6e 65 77 20 66 72 61 |create a| new fra|
|00001ee0| 6d 65 20 61 6e 64 20 6c | 61 62 65 6c 20 69 74 20 |me and l|abel it |
|00001ef0| 20 53 74 6f 72 61 67 65 | 2e 20 20 20 47 6f 20 61 | Storage|. Go a|
|00001f00| 68 65 61 64 20 61 6e 64 | 20 20 75 73 65 20 44 52 |head and| use DR|
|00001f10| 41 47 0d 28 46 33 29 20 | 20 61 6e 64 20 53 49 5a |AG.(F3) | and SIZ|
|00001f20| 45 20 28 46 34 29 20 20 | 74 6f 20 64 72 61 67 20 |E (F4) |to drag |
|00001f30| 61 6e 64 20 73 69 7a 65 | 20 69 74 20 73 6f 20 74 |and size| it so t|
|00001f40| 68 61 74 20 69 74 20 69 | 73 20 69 6e 20 6f 6e 65 |hat it i|s in one|
|00001f50| 20 63 6f 72 6e 65 72 20 | 6f 66 20 74 68 65 0d 64 | corner |of the.d|
|00001f60| 65 73 6b 2c 20 61 6e 64 | 20 73 68 6f 77 73 20 61 |esk, and| shows a|
|00001f70| 62 6f 75 74 20 6f 6e 65 | 20 72 6f 77 20 61 6e 64 |bout one| row and|
|00001f80| 20 74 65 6e 20 63 6f 6c | 75 6d 6e 73 20 69 6e 20 | ten col|umns in |
|00001f90| 74 68 65 20 63 6f 6e 74 | 65 6e 74 73 2e 20 20 54 |the cont|ents. T|
|00001fa0| 68 69 73 20 69 73 20 6e | 6f 74 0d 63 72 75 63 69 |his is n|ot.cruci|
|00001fb0| 61 6c 2c 20 20 62 75 74 | 20 64 6f 65 73 20 6d 61 |al, but| does ma|
|00001fc0| 6b 65 20 69 74 20 63 6f | 6e 76 65 6e 69 65 6e 74 |ke it co|nvenient|
|00001fd0| 20 74 6f 20 77 61 74 63 | 68 20 20 77 68 61 74 20 | to watc|h what |
|00001fe0| 69 73 20 67 6f 69 6e 67 | 20 6f 6e 20 20 77 69 74 |is going| on wit|
|00001ff0| 68 20 74 68 61 74 0d 66 | 72 61 6d 65 2e 20 20 4e |h that.f|rame. N|
|00002000| 6f 77 2c 20 65 64 69 74 | 20 74 68 65 20 66 6f 72 |ow, edit| the for|
|00002010| 6d 75 6c 61 20 69 6e 20 | 4d 65 6d 6f 72 79 20 74 |mula in |Memory t|
|00002020| 6f 20 6c 6f 6f 6b 20 6c | 69 6b 65 20 74 68 69 73 |o look l|ike this|
|00002030| 3a ff 02 00 4b 20 ff 02 | 00 4b 3b 20 53 68 6f 77 |:...K ..|.K; Show|
|00002040| 20 6d 65 6d 6f 72 79 20 | 72 65 6d 61 69 6e 69 6e | memory |remainin|
|00002050| 67 2e ff 02 00 4b 40 65 | 72 61 73 65 70 72 6f 6d |g....K@e|raseprom|
|00002060| 70 74 2c ff 02 00 4b 73 | 74 6f 72 61 67 65 20 3a |pt,...Ks|torage :|
|00002070| 3d 20 40 6d 65 6d 61 76 | 61 69 6c 2c ff 02 00 4b |= @memav|ail,...K|
|00002080| 40 70 72 6f 6d 70 74 28 | 20 22 59 6f 75 20 68 61 |@prompt(| "You ha|
|00002090| 76 65 20 22 20 26 ff 02 | 00 4b 20 20 20 20 20 20 |ve " &..|.K |
|000020a0| 20 20 20 40 62 75 73 69 | 6e 65 73 73 28 20 53 74 | @busi|ness( St|
|000020b0| 6f 72 61 67 65 2c 20 30 | 29 20 26 ff 02 00 4b 20 |orage, 0|) &...K |
|000020c0| 20 20 20 20 20 20 20 20 | 22 20 62 79 74 65 73 20 | |" bytes |
|000020d0| 72 65 6d 61 69 6e 69 6e | 67 20 6f 6e 20 74 68 65 |remainin|g on the|
|000020e0| 20 64 65 73 6b 74 6f 70 | 2e 22 20 29 ff 02 00 4b | desktop|." )...K|
|000020f0| 20 ff 02 00 4b 54 68 65 | 20 20 6f 6e 6c 79 20 63 | ...KThe| only c|
|00002100| 68 61 6e 67 65 20 69 6e | 20 20 74 68 65 20 72 65 |hange in| the re|
|00002110| 73 75 6c 74 20 20 79 6f | 75 20 77 69 6c 6c 20 73 |sult yo|u will s|
|00002120| 65 65 20 20 69 73 20 61 | 20 73 6c 69 67 68 74 20 |ee is a| slight |
|00002130| 64 65 63 72 65 61 73 65 | 20 20 69 6e 20 74 68 65 |decrease| in the|
|00002140| 0d 76 61 6c 75 65 20 6f | 66 20 6d 65 6d 6f 72 79 |.value o|f memory|
|00002150| 20 61 76 61 69 6c 61 62 | 6c 65 20 20 62 65 63 61 | availab|le beca|
|00002160| 75 73 65 20 6f 66 20 74 | 68 65 20 20 61 64 64 69 |use of t|he addi|
|00002170| 74 69 6f 6e 61 6c 20 6c | 69 6e 65 20 77 65 20 20 |tional l|ine we |
|00002180| 61 64 64 65 64 20 74 6f | 20 74 68 65 0d 70 72 6f |added to| the.pro|
|00002190| 67 72 61 6d 2e 20 20 20 | 4e 6f 77 20 74 68 65 20 |gram. |Now the |
|000021a0| 53 74 6f 72 61 67 65 20 | 66 72 61 6d 65 20 73 68 |Storage |frame sh|
|000021b0| 6f 77 73 20 74 68 61 74 | 20 76 61 6c 75 65 20 69 |ows that| value i|
|000021c0| 6e 20 69 74 73 20 63 6f | 6e 74 65 6e 74 73 2e 20 |n its co|ntents. |
|000021d0| 20 57 68 61 74 20 77 65 | 0d 68 61 76 65 20 64 6f | What we|.have do|
|000021e0| 6e 65 20 68 65 72 65 20 | 69 73 20 20 75 73 65 20 |ne here |is use |
|000021f0| 61 20 66 72 61 6d 65 20 | 61 73 20 20 61 20 76 61 |a frame |as a va|
|00002200| 72 69 61 62 6c 65 2e 20 | 20 20 59 6f 75 20 63 61 |riable. | You ca|
|00002210| 6e 20 64 6f 20 20 74 68 | 65 20 73 61 6d 65 20 74 |n do th|e same t|
|00002220| 68 69 6e 67 0d 77 69 74 | 68 20 61 20 73 70 72 65 |hing.wit|h a spre|
|00002230| 61 64 73 68 65 65 74 20 | 63 65 6c 6c 2c 20 20 74 |adsheet |cell, t|
|00002240| 68 61 74 20 69 73 2c 20 | 70 75 74 20 74 68 65 20 |hat is, |put the |
|00002250| 76 61 6c 75 65 20 6f 66 | 20 6d 65 6d 6f 72 79 20 |value of| memory |
|00002260| 72 65 6d 61 69 6e 69 6e | 67 20 69 6e 74 6f 20 61 |remainin|g into a|
|00002270| 0d 70 61 72 74 69 63 75 | 6c 61 72 20 63 65 6c 6c |.particu|lar cell|
|00002280| 2e 20 20 20 46 69 72 73 | 74 2c 20 20 64 65 6c 65 |. Firs|t, dele|
|00002290| 74 65 20 74 68 65 20 53 | 74 6f 72 61 67 65 20 66 |te the S|torage f|
|000022a0| 72 61 6d 65 2c 20 20 74 | 68 65 6e 20 63 72 65 61 |rame, t|hen crea|
|000022b0| 74 65 20 61 20 73 70 72 | 65 61 64 2d 0d 73 68 65 |te a spr|ead-.she|
|000022c0| 65 74 20 20 66 72 61 6d | 65 2c 20 20 6c 61 62 65 |et fram|e, labe|
|000022d0| 6c 20 69 74 20 53 74 6f | 72 61 67 65 2c 20 20 61 |l it Sto|rage, a|
|000022e0| 6e 64 20 65 64 69 74 20 | 74 68 65 20 66 6f 72 6d |nd edit |the form|
|000022f0| 75 6c 61 20 6f 66 20 20 | 4d 65 6d 6f 72 79 20 74 |ula of |Memory t|
|00002300| 6f 20 63 68 61 6e 67 65 | 0d 65 61 63 68 20 6f 63 |o change|.each oc|
|00002310| 63 75 72 72 65 6e 63 65 | 20 6f 66 20 74 68 65 20 |currence| of the |
|00002320| 77 6f 72 64 20 22 73 74 | 6f 72 61 67 65 22 20 74 |word "st|orage" t|
|00002330| 6f 20 22 53 74 6f 72 61 | 67 65 2e 41 31 2e 22 20 |o "Stora|ge.A1." |
|00002340| 52 45 43 41 4c 43 69 6e | 67 20 4d 65 6d 6f 72 79 |RECALCin|g Memory|
|00002350| 20 6e 6f 77 0d 77 69 6c | 6c 20 70 75 74 20 74 68 | now.wil|l put th|
|00002360| 65 20 72 65 73 75 6c 74 | 20 69 6e 74 6f 20 63 65 |e result| into ce|
|00002370| 6c 6c 20 41 31 20 20 6f | 66 20 74 68 65 20 73 70 |ll A1 o|f the sp|
|00002380| 72 65 61 64 73 68 65 65 | 74 2e 20 20 20 54 68 65 |readshee|t. The|
|00002390| 20 69 6d 70 6f 72 74 61 | 6e 74 20 74 68 69 6e 67 | importa|nt thing|
|000023a0| 0d 74 6f 20 6e 6f 74 65 | 20 20 68 65 72 65 20 69 |.to note| here i|
|000023b0| 73 20 74 68 61 74 20 20 | 61 6e 79 20 66 72 61 6d |s that |any fram|
|000023c0| 65 20 6f 72 20 20 63 65 | 6c 6c 20 63 61 6e 20 20 |e or ce|ll can |
|000023d0| 62 65 20 75 73 65 64 20 | 6a 75 73 74 20 20 6c 69 |be used |just li|
|000023e0| 6b 65 20 61 20 70 72 6f | 67 72 61 6d 0d 76 61 72 |ke a pro|gram.var|
|000023f0| 69 61 62 6c 65 2e ff 02 | 00 4b 20 ff 02 00 4b 47 |iable...|.K ...KG|
|00002400| 72 65 61 74 21 20 20 20 | 57 65 27 72 65 20 6d 6f |reat! |We're mo|
|00002410| 76 69 6e 67 20 20 61 6c | 6f 6e 67 20 20 6a 75 73 |ving al|ong jus|
|00002420| 74 20 20 66 69 6e 65 2e | 20 20 20 54 68 65 72 65 |t fine.| There|
|00002430| 27 73 20 20 6f 6e 65 20 | 20 6d 6f 72 65 20 20 77 |'s one | more w|
|00002440| 61 79 20 20 74 6f 20 75 | 73 65 0d 76 61 72 69 61 |ay to u|se.varia|
|00002450| 62 6c 65 73 20 74 68 61 | 74 20 49 20 77 61 6e 74 |bles tha|t I want|
|00002460| 20 74 6f 20 74 65 6c 6c | 20 79 6f 75 20 61 62 6f | to tell| you abo|
|00002470| 75 74 2c 20 20 61 6e 64 | 20 74 68 65 6e 20 79 6f |ut, and| then yo|
|00002480| 75 20 63 61 6e 20 67 65 | 74 20 62 61 63 6b 20 20 |u can ge|t back |
|00002490| 74 6f 20 61 6c 6c 0d 74 | 68 6f 73 65 20 20 69 6d |to all.t|hose im|
|000024a0| 70 6f 72 74 61 6e 74 20 | 20 70 72 6f 67 72 61 6d |portant | program|
|000024b0| 73 20 20 79 6f 75 27 72 | 65 20 20 77 72 69 74 69 |s you'r|e writi|
|000024c0| 6e 67 2e 20 20 20 46 69 | 72 73 74 2c 20 20 64 65 |ng. Fi|rst, de|
|000024d0| 6c 65 74 65 20 20 74 68 | 61 74 20 53 74 6f 72 61 |lete th|at Stora|
|000024e0| 67 65 0d 73 70 72 65 61 | 64 73 68 65 65 74 2c 20 |ge.sprea|dsheet, |
|000024f0| 61 6e 64 20 74 68 65 6e | 20 65 64 69 74 20 74 68 |and then| edit th|
|00002500| 65 20 66 6f 72 6d 75 6c | 61 20 69 6e 20 4d 65 6d |e formul|a in Mem|
|00002510| 6f 72 79 20 74 6f 20 6c | 6f 6f 6b 20 6c 69 6b 65 |ory to l|ook like|
|00002520| 20 74 68 69 73 3a ff 02 | 00 4b 20 ff 02 00 4b 3b | this:..|.K ...K;|
|00002530| 20 53 68 6f 77 20 6d 65 | 6d 6f 72 79 20 72 65 6d | Show me|mory rem|
|00002540| 61 69 6e 69 6e 67 2e ff | 02 00 4b 40 6c 6f 63 61 |aining..|..K@loca|
|00002550| 6c 28 20 73 74 6f 72 61 | 67 65 20 29 2c ff 02 00 |l( stora|ge ),...|
|00002560| 4b 40 65 72 61 73 65 70 | 72 6f 6d 70 74 2c ff 02 |K@erasep|rompt,..|
|00002570| 00 4b 73 74 6f 72 61 67 | 65 20 3a 3d 20 40 6d 65 |.Kstorag|e := @me|
|00002580| 6d 61 76 61 69 6c 2c ff | 02 00 4b 40 70 72 6f 6d |mavail,.|..K@prom|
|00002590| 70 74 28 20 22 59 6f 75 | 20 68 61 76 65 20 22 20 |pt( "You| have " |
|000025a0| 26 ff 02 00 4b 20 20 20 | 20 20 20 20 20 20 40 62 |&...K | @b|
|000025b0| 75 73 69 6e 65 73 73 28 | 20 53 74 6f 72 61 67 65 |usiness(| Storage|
|000025c0| 2c 30 20 29 20 26 ff 02 | 00 4b 20 20 20 20 20 20 |,0 ) &..|.K |
|000025d0| 20 20 20 22 20 62 79 74 | 65 73 20 72 65 6d 61 69 | " byt|es remai|
|000025e0| 6e 69 6e 67 20 6f 6e 20 | 74 68 65 20 64 65 73 6b |ning on |the desk|
|000025f0| 74 6f 70 2e 22 20 29 ff | 02 00 4b 20 ff 02 00 4b |top." ).|..K ...K|
|00002600| 59 6f 75 20 68 61 76 65 | 20 6a 75 73 74 20 62 65 |You have| just be|
|00002610| 65 6e 20 69 6e 74 72 6f | 64 75 63 65 64 20 74 6f |en intro|duced to|
|00002620| 20 6c 6f 63 61 6c 20 76 | 61 72 69 61 62 6c 65 73 | local v|ariables|
|00002630| 2e 20 20 54 68 69 6e 6b | 20 6f 66 20 74 68 65 6d |. Think| of them|
|00002640| 20 61 73 20 22 70 69 67 | 65 6f 6e 0d 68 6f 6c 65 | as "pig|eon.hole|
|00002650| 73 22 2c 20 20 6f 72 20 | 6d 61 69 6c 20 73 6c 6f |s", or |mail slo|
|00002660| 74 73 2e 20 20 45 61 63 | 68 20 6c 6f 63 61 6c 20 |ts. Eac|h local |
|00002670| 76 61 72 69 61 62 6c 65 | 20 6d 75 73 74 20 62 65 |variable| must be|
|00002680| 20 64 65 63 6c 61 72 65 | 64 20 69 6e 20 74 68 65 | declare|d in the|
|00002690| 20 40 6c 6f 63 61 6c 0d | 73 74 61 74 65 6d 65 6e | @local.|statemen|
|000026a0| 74 20 62 65 66 6f 72 65 | 20 69 74 20 69 73 20 75 |t before| it is u|
|000026b0| 73 65 64 2c 20 20 61 6e | 64 20 65 61 63 68 20 76 |sed, an|d each v|
|000026c0| 61 72 69 61 62 6c 65 20 | 20 63 61 6e 20 68 6f 6c |ariable | can hol|
|000026d0| 64 20 20 6f 6e 65 20 76 | 61 6c 75 65 2e 20 20 54 |d one v|alue. T|
|000026e0| 68 61 74 0d 76 61 6c 75 | 65 20 20 63 61 6e 2c 20 |hat.valu|e can, |
|000026f0| 20 6f 66 20 20 63 6f 75 | 72 73 65 2c 20 20 62 65 | of cou|rse, be|
|00002700| 20 61 20 6e 75 6d 62 65 | 72 20 20 6f 72 20 20 61 | a numbe|r or a|
|00002710| 20 20 63 68 61 72 61 63 | 74 65 72 20 20 73 74 72 | charac|ter str|
|00002720| 69 6e 67 2e 20 20 20 54 | 68 65 20 72 65 61 6c 0d |ing. T|he real.|
|00002730| 64 69 66 66 65 72 65 6e | 63 65 20 62 65 74 77 65 |differen|ce betwe|
|00002740| 65 6e 20 75 73 69 6e 67 | 20 61 20 6c 6f 63 61 6c |en using| a local|
|00002750| 20 76 61 72 69 61 62 6c | 65 20 20 61 6e 64 20 75 | variabl|e and u|
|00002760| 73 69 6e 67 20 61 20 20 | 66 72 61 6d 65 20 20 69 |sing a |frame i|
|00002770| 73 20 20 74 68 61 74 20 | 74 68 65 0d 6c 6f 63 61 |s that |the.loca|
|00002780| 6c 20 20 76 61 72 69 61 | 62 6c 65 20 20 65 78 69 |l varia|ble exi|
|00002790| 73 74 73 20 20 6f 6e 6c | 79 20 20 69 6e 20 20 74 |sts onl|y in t|
|000027a0| 68 65 20 70 72 6f 67 72 | 61 6d 20 74 68 61 74 20 |he progr|am that |
|000027b0| 20 64 65 63 6c 61 72 65 | 64 20 20 69 74 20 20 61 | declare|d it a|
|000027c0| 6e 64 20 77 69 6c 6c 0d | 64 69 73 61 70 70 65 61 |nd will.|disappea|
|000027d0| 72 20 20 77 68 65 6e 20 | 20 74 68 65 20 70 72 6f |r when | the pro|
|000027e0| 67 72 61 6d 20 69 73 20 | 20 66 69 6e 69 73 68 65 |gram is | finishe|
|000027f0| 64 2c 20 20 77 68 65 72 | 65 61 73 20 20 74 68 65 |d, wher|eas the|
|00002800| 20 66 72 61 6d 65 20 20 | 76 61 72 69 61 62 6c 65 | frame |variable|
|00002810| 20 69 73 0d 69 6e 64 65 | 70 65 6e 64 65 6e 74 20 | is.inde|pendent |
|00002820| 61 6e 64 20 63 61 6e 20 | 62 65 20 75 73 65 64 20 |and can |be used |
|00002830| 62 79 20 61 6e 79 20 6e | 75 6d 62 65 72 20 6f 66 |by any n|umber of|
|00002840| 20 70 72 6f 67 72 61 6d | 73 20 61 73 20 77 65 6c | program|s as wel|
|00002850| 6c 20 61 73 20 68 61 76 | 69 6e 67 20 61 6c 6c 0d |l as hav|ing all.|
|00002860| 74 68 65 20 20 6e 6f 72 | 6d 61 6c 20 20 66 72 61 |the nor|mal fra|
|00002870| 6d 65 20 63 61 70 61 62 | 69 6c 69 74 69 65 73 20 |me capab|ilities |
|00002880| 20 28 74 68 61 74 20 69 | 73 20 73 69 7a 69 6e 67 | (that i|s sizing|
|00002890| 2c 20 20 64 72 61 67 67 | 69 6e 67 2c 20 68 69 64 |, dragg|ing, hid|
|000028a0| 69 6e 67 2c 20 65 74 63 | 2e 29 2e 0d 4c 6f 63 61 |ing, etc|.)..Loca|
|000028b0| 6c 20 20 76 61 72 69 61 | 62 6c 65 73 20 61 72 65 |l varia|bles are|
|000028c0| 20 75 73 65 64 20 20 66 | 6f 72 20 74 65 6d 70 6f | used f|or tempo|
|000028d0| 72 61 72 79 20 73 74 6f | 72 61 67 65 20 20 6f 66 |rary sto|rage of|
|000028e0| 20 20 76 61 6c 75 65 73 | 2c 20 20 6c 69 6b 65 20 | values|, like |
|000028f0| 20 69 66 20 79 6f 75 0d | 77 61 6e 74 65 64 20 74 | if you.|wanted t|
|00002900| 6f 20 73 65 74 20 61 73 | 69 64 65 20 61 6e 20 69 |o set as|ide an i|
|00002910| 6e 74 65 72 6d 65 64 69 | 61 74 65 20 20 72 65 73 |ntermedi|ate res|
|00002920| 75 6c 74 20 77 68 69 6c | 65 20 79 6f 75 20 20 70 |ult whil|e you p|
|00002930| 65 72 66 6f 72 6d 65 64 | 20 73 6f 6d 65 20 6f 74 |erformed| some ot|
|00002940| 68 65 72 0d 63 61 6c 63 | 75 6c 61 74 69 6f 6e 73 |her.calc|ulations|
|00002950| 2c 20 20 61 6e 64 20 74 | 68 65 6e 20 20 77 61 6e |, and t|hen wan|
|00002960| 74 65 64 20 74 6f 20 72 | 65 74 72 69 65 76 65 20 |ted to r|etrieve |
|00002970| 20 74 68 65 20 66 69 72 | 73 74 20 76 61 6c 75 65 | the fir|st value|
|00002980| 20 74 6f 20 20 75 73 65 | 20 61 67 61 69 6e 2e 0d | to use| again..|
|00002990| 54 68 65 20 62 65 73 74 | 20 61 6e 61 6c 6f 67 79 |The best| analogy|
|000029a0| 20 66 6f 72 20 74 68 69 | 73 20 20 69 73 20 61 20 | for thi|s is a |
|000029b0| 20 64 65 73 6b 74 6f 70 | 20 63 61 6c 63 75 6c 61 | desktop| calcula|
|000029c0| 74 6f 72 2e 20 20 20 53 | 75 72 65 6c 79 20 79 6f |tor. S|urely yo|
|000029d0| 75 27 76 65 20 73 65 65 | 6e 20 61 0d 63 61 6c 63 |u've see|n a.calc|
|000029e0| 75 6c 61 74 6f 72 20 74 | 68 61 74 20 20 68 61 73 |ulator t|hat has|
|000029f0| 20 61 20 6d 65 6d 6f 72 | 79 20 20 66 75 6e 63 74 | a memor|y funct|
|00002a00| 69 6f 6e 20 28 6c 69 6b | 65 20 4d 2b 2c 4d 2d 2c |ion (lik|e M+,M-,|
|00002a10| 4d 52 29 3f 20 20 20 57 | 65 6c 6c 2c 20 74 75 72 |MR)? W|ell, tur|
|00002a20| 6e 69 6e 67 20 6f 6e 0d | 74 68 65 20 20 63 61 6c |ning on.|the cal|
|00002a30| 63 75 6c 61 74 6f 72 20 | 69 73 20 6c 69 6b 65 20 |culator |is like |
|00002a40| 20 72 75 6e 6e 69 6e 67 | 20 61 20 46 52 45 44 20 | running| a FRED |
|00002a50| 20 70 72 6f 67 72 61 6d | 3b 20 20 73 74 6f 72 69 | program|; stori|
|00002a60| 6e 67 20 73 6f 6d 65 74 | 68 69 6e 67 20 74 6f 20 |ng somet|hing to |
|00002a70| 74 68 65 0d 63 61 6c 63 | 75 6c 61 74 6f 72 27 73 |the.calc|ulator's|
|00002a80| 20 6d 65 6d 6f 72 79 20 | 69 73 20 6c 69 6b 65 20 | memory |is like |
|00002a90| 73 74 6f 72 69 6e 67 20 | 74 6f 20 61 20 46 52 45 |storing |to a FRE|
|00002aa0| 44 20 6c 6f 63 61 6c 20 | 76 61 72 69 61 62 6c 65 |D local |variable|
|00002ab0| 2c 20 77 72 69 74 69 6e | 67 20 73 6f 6d 65 2d 0d |, writin|g some-.|
|00002ac0| 74 68 69 6e 67 20 6f 6e | 20 61 20 70 69 65 63 65 |thing on| a piece|
|00002ad0| 20 6f 66 20 70 61 70 65 | 72 20 6e 65 78 74 20 74 | of pape|r next t|
|00002ae0| 6f 20 74 68 65 20 63 61 | 6c 63 75 6c 61 74 6f 72 |o the ca|lculator|
|00002af0| 20 69 73 20 6c 69 6b 65 | 20 73 74 6f 72 69 6e 67 | is like| storing|
|00002b00| 20 74 6f 20 61 20 66 72 | 61 6d 65 0d 76 61 72 69 | to a fr|ame.vari|
|00002b10| 61 62 6c 65 2c 20 20 61 | 6e 64 20 74 68 65 20 65 |able, a|nd the e|
|00002b20| 6e 64 20 6f 66 20 61 20 | 46 52 45 44 20 70 72 6f |nd of a |FRED pro|
|00002b30| 67 72 61 6d 20 69 73 20 | 6c 69 6b 65 20 74 75 72 |gram is |like tur|
|00002b40| 6e 69 6e 67 20 6f 66 66 | 20 74 68 65 20 63 61 6c |ning off| the cal|
|00002b50| 63 75 6c 61 74 6f 72 0d | 62 65 63 61 75 73 65 20 |culator.|because |
|00002b60| 62 6f 74 68 20 74 68 65 | 20 63 61 6c 63 75 6c 61 |both the| calcula|
|00002b70| 74 6f 72 27 73 20 20 6d | 65 6d 6f 72 79 20 20 61 |tor's m|emory a|
|00002b80| 6e 64 20 46 52 45 44 27 | 73 20 6c 6f 63 61 6c 20 |nd FRED'|s local |
|00002b90| 20 76 61 72 69 61 62 6c | 65 73 20 77 6f 75 6c 64 | variabl|es would|
|00002ba0| 20 62 65 0d 6c 6f 73 74 | 2e ff 02 00 4b 20 ff 02 | be.lost|....K ..|
|00002bb0| 00 4b 54 68 61 74 27 73 | 20 61 62 6f 75 74 20 69 |.KThat's| about i|
|00002bc0| 74 20 66 6f 72 20 74 68 | 69 73 20 73 65 73 73 69 |t for th|is sessi|
|00002bd0| 6f 6e 2c 20 73 6f 20 67 | 6f 20 74 72 79 20 6f 75 |on, so g|o try ou|
|00002be0| 74 20 73 6f 6d 65 20 6f | 66 20 74 68 65 73 65 20 |t some o|f these |
|00002bf0| 63 6f 6e 63 65 70 74 73 | 2c 20 61 6e 64 0d 70 6c |concepts|, and.pl|
|00002c00| 65 61 73 65 2c 20 20 70 | 6c 65 61 73 65 2c 20 20 |ease, p|lease, |
|00002c10| 70 6c 65 61 73 65 20 65 | 78 70 65 72 69 6d 65 6e |please e|xperimen|
|00002c20| 74 21 20 20 20 54 68 65 | 72 65 20 20 69 73 20 20 |t! The|re is |
|00002c30| 6e 6f 20 20 62 65 74 74 | 65 72 20 20 77 61 79 20 |no bett|er way |
|00002c40| 20 74 6f 20 6c 65 61 72 | 6e 0d 70 72 6f 67 72 61 | to lear|n.progra|
|00002c50| 6d 6d 69 6e 67 20 74 68 | 61 6e 20 68 61 6e 64 73 |mming th|an hands|
|00002c60| 2d 6f 6e 20 65 78 70 65 | 72 69 65 6e 63 65 2e 20 |-on expe|rience. |
|00002c70| 20 49 66 20 79 6f 75 20 | 64 6f 6e 27 74 20 61 6c | If you |don't al|
|00002c80| 72 65 61 64 79 20 68 61 | 76 65 20 46 52 41 4d 45 |ready ha|ve FRAME|
|00002c90| 57 4f 52 4b 3a 0d 41 20 | 50 72 6f 67 72 61 6d 6d |WORK:.A |Programm|
|00002ca0| 65 72 73 27 73 20 52 65 | 66 65 72 65 6e 63 65 2c |ers's Re|ference,|
|00002cb0| 20 49 20 73 75 67 67 65 | 73 74 20 79 6f 75 20 67 | I sugge|st you g|
|00002cc0| 65 74 20 69 74 2e 20 20 | 49 74 20 69 73 20 61 20 |et it. |It is a |
|00002cd0| 76 61 6c 75 61 62 6c 65 | 20 74 6f 6f 6c 20 66 6f |valuable| tool fo|
|00002ce0| 72 0d 61 6e 79 6f 6e 65 | 20 77 68 6f 20 77 61 6e |r.anyone| who wan|
|00002cf0| 74 73 20 74 6f 20 6c 65 | 61 72 6e 20 46 52 45 44 |ts to le|arn FRED|
|00002d00| 2e 20 20 20 4c 6f 6f 6b | 20 66 6f 72 20 50 61 72 |. Look| for Par|
|00002d10| 74 20 32 20 20 6f 66 20 | 41 72 6d 63 68 61 69 72 |t 2 of |Armchair|
|00002d20| 20 20 46 52 45 44 20 69 | 6e 20 74 68 65 0d 6e 65 | FRED i|n the.ne|
|00002d30| 78 74 20 69 73 73 75 65 | 20 6f 66 20 54 65 63 68 |xt issue| of Tech|
|00002d40| 4e 6f 74 65 73 2e ff 01 | 00 4b 00 ff ff ff ff ff |Notes...|.K......|
|00002d50| 04 00 26 02 02 00 07 61 | 01 00 01 00 4c 00 11 00 |..&....a|....L...|
|00002d60| 02 00 03 00 4d 00 13 00 | 01 00 02 00 4e 00 14 00 |....M...|....N...|
|00002d70| 01 00 02 00 4e 00 14 00 | 04 00 02 00 d6 02 00 00 |....N...|........|
|00002d80| 00 00 00 00 00 00 00 00 | 4b 05 02 00 00 4b 00 00 |........|K....K..|
|00002d90| 03 00 28 02 18 82 00 00 | 00 01 00 00 02 00 16 00 |..(.....|........|
|00002da0| 41 72 6d 63 68 61 69 72 | 20 46 52 45 44 20 2d 20 |Armchair| FRED - |
|00002db0| 50 61 72 74 20 31 00 ff | ff ff ff ff ff ff ff ff |Part 1..|........|
|00002dc0| 02 00 da 00 18 82 00 00 | 00 01 00 00 02 00 06 00 |........|........|
|00002dd0| 40 6e 70 28 32 29 00 ff | ff ff ff ff ff ff ff ff |@np(2)..|........|
|00002de0| 30 03 3a 01 18 80 00 00 | 00 02 00 00 02 00 00 00 |0.:.....|........|
|00002df0| 00 00 00 00 00 00 00 00 | 0b 06 1c 02 12 06 01 00 |........|........|
|00002e00| 02 00 1b 32 0d 02 20 20 | 20 20 20 62 79 20 4b 65 |...2.. | by Ke|
|00002e10| 6e 74 20 49 72 77 69 6e | ff 02 00 4b ff 02 00 4b |nt Irwin|...K...K|
|00002e20| 49 6e 74 72 6f 64 75 63 | 74 69 6f 6e ff 02 00 4b |Introduc|tion...K|
|00002e30| ff 02 00 4b 57 65 6c 63 | 6f 6d 65 20 62 61 63 6b |...KWelc|ome back|
|00002e40| 20 74 6f 20 74 68 65 20 | 41 72 6d 63 68 61 69 72 | to the |Armchair|
|00002e50| 21 20 20 49 20 68 6f 70 | 65 20 79 6f 75 20 61 72 |! I hop|e you ar|
|00002e60| 65 20 63 6f 6d 66 6f 72 | 74 61 62 6c 79 20 73 65 |e comfor|tably se|
|00002e70| 61 74 65 64 2c 20 77 69 | 74 68 20 79 6f 75 72 0d |ated, wi|th your.|
|00002e80| 63 6f 6d 70 75 74 65 72 | 20 73 69 74 74 69 6e 67 |computer| sitting|
|00002e90| 20 6e 65 61 72 62 79 2c | 20 20 61 6e 64 20 79 6f | nearby,| and yo|
|00002ea0| 75 72 20 6d 69 6e 64 20 | 66 72 65 73 68 20 20 61 |ur mind |fresh a|
|00002eb0| 6e 64 20 72 65 61 64 79 | 20 66 6f 72 20 6e 65 77 |nd ready| for new|
|00002ec0| 20 20 69 64 65 61 73 2e | 20 49 6e 0d 74 68 69 73 | ideas.| In.this|
|00002ed0| 20 63 68 61 70 74 65 72 | 20 6f 66 20 22 41 72 6d | chapter| of "Arm|
|00002ee0| 63 68 61 69 72 20 46 52 | 45 44 22 20 20 77 65 20 |chair FR|ED" we |
|00002ef0| 77 69 6c 6c 20 63 6f 6e | 74 69 6e 75 65 20 6f 75 |will con|tinue ou|
|00002f00| 72 20 64 69 73 63 75 73 | 73 69 6f 6e 20 6f 66 20 |r discus|sion of |
|00002f10| 73 74 6f 72 61 67 65 0d | 74 65 63 68 6e 69 71 75 |storage.|techniqu|
|00002f20| 65 73 2c 20 20 61 6e 64 | 20 74 68 65 6e 20 20 6d |es, and| then m|
|00002f30| 6f 76 65 20 20 6f 6e 20 | 20 74 6f 20 20 75 73 69 |ove on | to usi|
|00002f40| 6e 67 20 73 70 65 63 69 | 61 6c 20 66 75 6e 63 74 |ng speci|al funct|
|00002f50| 69 6f 6e 73 20 20 74 6f | 20 6d 61 6e 69 70 75 6c |ions to| manipul|
|00002f60| 61 74 65 0d 6e 75 6d 62 | 65 72 73 20 20 61 6e 64 |ate.numb|ers and|
|00002f70| 20 73 74 72 69 6e 67 73 | 2e 20 20 20 41 6e 64 20 | strings|. And |
|00002f80| 20 73 6f 2c 20 20 77 69 | 74 68 6f 75 74 20 66 75 | so, wi|thout fu|
|00002f90| 72 74 68 65 72 20 20 61 | 64 6f 2e 2e 2e 66 65 65 |rther a|do...fee|
|00002fa0| 74 20 75 70 2c 20 54 65 | 63 68 4e 6f 74 65 73 0d |t up, Te|chNotes.|
|00002fb0| 6f 70 65 6e 2c 20 77 65 | 27 72 65 20 6f 66 66 2e |open, we|'re off.|
|00002fc0| ff 02 00 4b ff 02 00 4b | ff 02 00 4b 4d 6f 72 65 |...K...K|...KMore|
|00002fd0| 20 61 62 6f 75 74 20 53 | 74 6f 72 61 67 65 ff 02 | about S|torage..|
|00002fe0| 00 4b ff 02 00 4b 53 69 | 6e 63 65 20 77 65 20 61 |.K...KSi|nce we a|
|00002ff0| 72 65 20 67 6f 69 6e 67 | 20 74 6f 20 74 61 6c 6b |re going| to talk|
|00003000| 20 61 62 6f 75 74 20 73 | 74 6f 72 61 67 65 2c 20 | about s|torage, |
|00003010| 20 69 74 20 69 73 20 61 | 20 67 6f 6f 64 20 20 69 | it is a| good i|
|00003020| 64 65 61 20 20 74 6f 20 | 64 69 73 63 75 73 73 20 |dea to |discuss |
|00003030| 61 0d 66 75 6e 63 74 69 | 6f 6e 20 74 68 61 74 20 |a.functi|on that |
|00003040| 20 61 63 74 75 61 6c 6c | 79 20 64 6f 65 73 20 6d | actuall|y does m|
|00003050| 6f 73 74 20 20 6f 66 20 | 74 68 65 20 20 73 74 6f |ost of |the sto|
|00003060| 72 69 6e 67 20 66 6f 72 | 20 75 73 2e 20 20 20 49 |ring for| us. I|
|00003070| 6e 20 6d 79 20 70 72 65 | 76 69 6f 75 73 0d 65 78 |n my pre|vious.ex|
|00003080| 61 6d 70 6c 65 73 2c 20 | 20 49 20 68 61 76 65 20 |amples, | I have |
|00003090| 66 72 65 65 6c 79 20 75 | 73 65 64 20 20 65 78 70 |freely u|sed exp|
|000030a0| 72 65 73 73 69 6f 6e 73 | 20 6c 69 6b 65 20 20 22 |ressions| like "|
|000030b0| 54 65 6d 70 20 3a 3d 20 | 20 31 30 22 20 61 6e 64 |Temp := | 10" and|
|000030c0| 20 68 61 76 65 20 6e 6f | 74 0d 65 78 70 6c 61 69 | have no|t.explai|
|000030d0| 6e 65 64 20 20 74 68 65 | 20 75 73 65 20 20 6f 66 |ned the| use of|
|000030e0| 20 20 74 68 65 20 20 22 | 3a 3d 22 20 20 73 79 6d | the "|:=" sym|
|000030f0| 62 6f 6c 2e 20 20 20 49 | 74 20 20 69 73 20 20 63 |bol. I|t is c|
|00003100| 61 6c 6c 65 64 20 20 74 | 68 65 20 61 73 73 69 67 |alled t|he assig|
|00003110| 6e 6d 65 6e 74 0d 6f 70 | 65 72 61 74 6f 72 2c 20 |nment.op|erator, |
|00003120| 20 61 6e 64 20 68 61 73 | 20 65 78 61 63 74 6c 79 | and has| exactly|
|00003130| 20 74 68 65 20 73 61 6d | 65 20 20 72 65 73 75 6c | the sam|e resul|
|00003140| 74 20 61 73 20 40 73 65 | 74 28 54 65 6d 70 2c 31 |t as @se|t(Temp,1|
|00003150| 30 29 2c 20 20 6d 65 61 | 6e 69 6e 67 20 74 68 61 |0), mea|ning tha|
|00003160| 74 0d 74 68 65 20 76 61 | 6c 75 65 20 31 30 20 20 |t.the va|lue 10 |
|00003170| 69 73 20 70 6c 61 63 65 | 64 20 69 6e 20 74 68 65 |is place|d in the|
|00003180| 20 76 61 72 69 61 62 6c | 65 20 54 65 6d 70 2e 20 | variabl|e Temp. |
|00003190| 54 65 6d 70 20 63 61 6e | 20 62 65 20 61 20 6c 6f |Temp can| be a lo|
|000031a0| 63 61 6c 20 76 61 72 69 | 61 62 6c 65 2c 0d 61 20 |cal vari|able,.a |
|000031b0| 66 72 61 6d 65 2c 20 20 | 6f 72 20 61 20 63 65 6c |frame, |or a cel|
|000031c0| 6c 2e 20 20 20 50 6c 65 | 61 73 65 20 6e 6f 74 65 |l. Ple|ase note|
|000031d0| 20 74 68 61 74 20 22 3a | 3d 22 20 20 69 73 20 6e | that ":|=" is n|
|000031e0| 6f 74 20 74 68 65 20 73 | 61 6d 65 20 20 61 73 20 |ot the s|ame as |
|000031f0| 22 3d 22 2e 20 20 54 68 | 65 0d 65 71 75 61 6c 73 |"=". Th|e.equals|
|00003200| 20 73 69 67 6e 20 20 61 | 6c 6f 6e 65 20 69 73 20 | sign a|lone is |
|00003210| 20 75 73 65 64 20 20 66 | 6f 72 20 63 6f 6d 70 61 | used f|or compa|
|00003220| 72 69 6e 67 20 74 77 6f | 20 76 61 6c 75 65 73 20 |ring two| values |
|00003230| 20 61 6e 64 20 64 6f 65 | 73 20 20 6e 6f 74 20 63 | and doe|s not c|
|00003240| 68 61 6e 67 65 0d 65 69 | 74 68 65 72 20 76 61 6c |hange.ei|ther val|
|00003250| 75 65 2e 20 20 20 45 71 | 75 69 76 61 6c 65 6e 63 |ue. Eq|uivalenc|
|00003260| 79 20 20 61 6e 64 20 6f | 74 68 65 72 20 63 6f 6d |y and o|ther com|
|00003270| 70 61 72 69 73 6f 6e 73 | 20 77 69 6c 6c 20 20 62 |parisons| will b|
|00003280| 65 20 20 64 69 73 63 75 | 73 73 65 64 20 69 6e 20 |e discu|ssed in |
|00003290| 61 0d 6c 61 74 65 72 20 | 41 72 6d 63 68 61 69 72 |a.later |Armchair|
|000032a0| 20 73 65 73 73 69 6f 6e | 2e ff 02 00 4b ff 02 00 | session|....K...|
|000032b0| 4b 42 65 66 6f 72 65 20 | 20 6d 6f 76 69 6e 67 20 |KBefore | moving |
|000032c0| 20 6f 6e 20 74 6f 20 61 | 6e 6f 74 68 65 72 20 66 | on to a|nother f|
|000032d0| 61 63 65 74 20 6f 66 20 | 20 70 72 6f 67 72 61 6d |acet of | program|
|000032e0| 6d 69 6e 67 2c 20 20 49 | 20 77 61 6e 74 20 20 74 |ming, I| want t|
|000032f0| 6f 20 64 65 73 63 72 69 | 62 65 20 61 0d 75 73 65 |o descri|be a.use|
|00003300| 66 75 6c 20 66 65 61 74 | 75 72 65 20 6f 66 20 73 |ful feat|ure of s|
|00003310| 74 6f 72 61 67 65 20 69 | 6e 20 46 72 61 6d 65 77 |torage i|n Framew|
|00003320| 6f 72 6b 2e 20 20 53 75 | 70 70 6f 73 65 20 74 68 |ork. Su|ppose th|
|00003330| 61 74 20 79 6f 75 20 68 | 61 76 65 20 61 20 77 6f |at you h|ave a wo|
|00003340| 72 64 20 66 72 61 6d 65 | 0d 63 61 6c 6c 65 64 20 |rd frame|.called |
|00003350| 4c 65 74 74 65 72 2c 20 | 77 68 69 63 68 20 63 6f |Letter, |which co|
|00003360| 6e 74 61 69 6e 73 20 61 | 62 6f 75 74 20 66 6f 75 |ntains a|bout fou|
|00003370| 72 20 70 61 67 65 73 20 | 6f 66 20 74 65 78 74 2e |r pages |of text.|
|00003380| 20 59 6f 75 20 64 65 63 | 69 64 65 20 74 68 61 74 | You dec|ide that|
|00003390| 20 74 68 65 0d 70 72 6f | 67 72 61 6d 20 79 6f 75 | the.pro|gram you|
|000033a0| 20 61 72 65 20 77 72 69 | 74 69 6e 67 20 6e 65 65 | are wri|ting nee|
|000033b0| 64 73 20 74 6f 20 77 6f | 72 6b 20 77 69 74 68 20 |ds to wo|rk with |
|000033c0| 20 74 68 61 74 20 66 72 | 61 6d 65 2c 20 20 6d 61 | that fr|ame, ma|
|000033d0| 79 62 65 20 62 65 63 61 | 75 73 65 20 79 6f 75 72 |ybe beca|use your|
|000033e0| 0d 70 72 6f 67 72 61 6d | 20 77 69 6c 6c 20 62 72 |.program| will br|
|000033f0| 65 61 6b 20 75 70 20 74 | 68 65 20 77 6f 72 64 20 |eak up t|he word |
|00003400| 66 72 61 6d 65 20 69 6e | 74 6f 20 73 65 76 65 72 |frame in|to sever|
|00003410| 61 6c 20 70 61 67 65 2d | 73 69 7a 65 64 20 20 66 |al page-|sized f|
|00003420| 72 61 6d 65 73 2e 20 57 | 65 20 64 6f 0d 6e 6f 74 |rames. W|e do.not|
|00003430| 20 6e 65 65 64 20 74 6f | 20 77 6f 72 72 79 20 61 | need to| worry a|
|00003440| 62 6f 75 74 20 74 68 65 | 20 61 63 74 75 61 6c 20 |bout the| actual |
|00003450| 70 72 6f 67 72 61 6d 20 | 20 72 69 67 68 74 20 6e |program | right n|
|00003460| 6f 77 2c 20 20 62 75 74 | 20 6c 65 74 20 75 73 20 |ow, but| let us |
|00003470| 63 6f 6e 73 69 64 65 72 | 0d 74 68 65 20 73 74 6f |consider|.the sto|
|00003480| 72 61 67 65 20 6f 70 74 | 69 6f 6e 73 2e ff 02 00 |rage opt|ions....|
|00003490| 4b ff 02 00 4b 49 74 20 | 77 6f 75 6c 64 20 62 65 |K...KIt |would be|
|000034a0| 20 76 65 72 79 20 63 6f | 6e 76 65 6e 69 65 6e 74 | very co|nvenient|
|000034b0| 20 74 6f 20 62 65 20 61 | 62 6c 65 20 74 6f 20 74 | to be a|ble to t|
|000034c0| 72 65 61 74 20 74 68 65 | 20 77 6f 72 64 20 20 66 |reat the| word f|
|000034d0| 72 61 6d 65 20 61 73 20 | 20 61 20 6c 61 72 67 65 |rame as | a large|
|000034e0| 0d 73 74 72 69 6e 67 20 | 20 76 61 72 69 61 62 6c |.string | variabl|
|000034f0| 65 20 61 6e 64 20 20 61 | 70 70 6c 79 20 46 52 45 |e and a|pply FRE|
|00003500| 44 27 73 20 73 74 72 69 | 6e 67 20 66 75 6e 63 74 |D's stri|ng funct|
|00003510| 69 6f 6e 73 20 74 6f 20 | 20 69 74 2e 20 20 20 54 |ions to | it. T|
|00003520| 68 69 73 20 69 73 20 71 | 75 69 74 65 0d 65 61 73 |his is q|uite.eas|
|00003530| 79 20 74 6f 20 64 6f 2e | 20 20 20 46 6f 72 20 65 |y to do.| For e|
|00003540| 78 61 6d 70 6c 65 2c 20 | 20 79 6f 75 20 77 61 6e |xample, | you wan|
|00003550| 74 20 74 6f 20 6b 6e 6f | 77 20 77 68 61 74 20 74 |t to kno|w what t|
|00003560| 68 65 20 32 30 30 74 68 | 20 63 68 61 72 61 63 74 |he 200th| charact|
|00003570| 65 72 20 69 73 20 69 6e | 0d 74 68 65 20 4c 65 74 |er is in|.the Let|
|00003580| 74 65 72 20 20 66 72 61 | 6d 65 2e 20 20 20 54 68 |ter fra|me. Th|
|00003590| 65 20 20 66 75 6e 63 74 | 69 6f 6e 20 40 6d 69 64 |e funct|ion @mid|
|000035a0| 20 72 65 74 75 72 6e 73 | 20 74 68 65 20 76 61 6c | returns| the val|
|000035b0| 75 65 20 20 6f 66 20 20 | 61 20 70 61 72 74 69 63 |ue of |a partic|
|000035c0| 75 6c 61 72 0d 73 74 72 | 69 6e 67 20 20 70 6f 72 |ular.str|ing por|
|000035d0| 74 69 6f 6e 2c 20 20 62 | 61 73 65 64 20 6f 6e 20 |tion, b|ased on |
|000035e0| 20 73 6f 6d 65 20 20 63 | 6f 6f 72 64 69 6e 61 74 | some c|oordinat|
|000035f0| 65 73 20 79 6f 75 20 67 | 69 76 65 20 20 69 74 2e |es you g|ive it.|
|00003600| 20 20 20 54 68 65 20 66 | 6f 6c 6c 6f 77 69 6e 67 | The f|ollowing|
|00003610| 0d 65 78 70 72 65 73 73 | 69 6f 6e 20 75 73 65 73 |.express|ion uses|
|00003620| 20 40 6d 69 64 20 20 74 | 6f 20 70 75 74 20 74 68 | @mid t|o put th|
|00003630| 65 20 20 32 30 30 74 68 | 20 63 68 61 72 61 63 74 |e 200th| charact|
|00003640| 65 72 20 66 72 6f 6d 20 | 20 4c 65 74 74 65 72 20 |er from | Letter |
|00003650| 69 6e 74 6f 20 61 6e 6f | 74 68 65 72 0d 66 72 61 |into ano|ther.fra|
|00003660| 6d 65 20 63 61 6c 6c 65 | 64 20 54 65 73 74 2c 20 |me calle|d Test, |
|00003670| 77 68 69 63 68 20 69 73 | 20 62 65 69 6e 67 20 75 |which is| being u|
|00003680| 73 65 64 20 61 73 20 61 | 20 76 61 72 69 61 62 6c |sed as a| variabl|
|00003690| 65 20 69 6e 20 6f 75 72 | 20 68 79 70 6f 74 68 65 |e in our| hypothe|
|000036a0| 74 69 63 61 6c ff 02 00 | 4b 70 72 6f 67 72 61 6d |tical...|Kprogram|
|000036b0| 2e ff 02 00 4b ff 02 00 | 4b 20 20 20 20 20 54 65 |....K...|K Te|
|000036c0| 73 74 20 3a 3d 20 40 6d | 69 64 28 20 4c 65 74 74 |st := @m|id( Lett|
|000036d0| 65 72 2c 32 30 30 2c 31 | 20 29 ff 02 00 4b ff 02 |er,200,1| )...K..|
|000036e0| 00 4b 4e 6f 74 65 20 74 | 68 65 20 74 68 72 65 65 |.KNote t|he three|
|000036f0| 20 69 74 65 6d 73 20 77 | 69 74 68 69 6e 20 74 68 | items w|ithin th|
|00003700| 65 20 20 70 61 72 65 6e | 74 68 65 73 65 73 20 74 |e paren|theses t|
|00003710| 68 61 74 20 61 72 65 20 | 20 73 65 70 61 72 61 74 |hat are | separat|
|00003720| 65 64 20 62 79 20 63 6f | 6d 6d 61 73 2e 0d 54 68 |ed by co|mmas..Th|
|00003730| 65 73 65 20 61 72 65 20 | 63 61 6c 6c 65 64 20 74 |ese are |called t|
|00003740| 68 65 20 22 61 72 67 75 | 6d 65 6e 74 73 22 20 20 |he "argu|ments" |
|00003750| 6f 66 20 61 20 66 75 6e | 63 74 69 6f 6e 2c 20 20 |of a fun|ction, |
|00003760| 61 6e 64 20 69 6e 20 74 | 68 65 20 63 61 73 65 20 |and in t|he case |
|00003770| 20 6f 66 20 40 6d 69 64 | 2c 0d 74 68 65 79 20 72 | of @mid|,.they r|
|00003780| 65 70 72 65 73 65 6e 74 | 20 74 68 65 20 73 74 72 |epresent| the str|
|00003790| 69 6e 67 20 20 74 6f 20 | 77 6f 72 6b 20 77 69 74 |ing to |work wit|
|000037a0| 68 2c 20 20 74 68 65 20 | 63 68 61 72 61 63 74 65 |h, the |characte|
|000037b0| 72 20 74 6f 20 73 74 61 | 72 74 20 20 77 69 74 68 |r to sta|rt with|
|000037c0| 2c 20 61 6e 64 0d 74 68 | 65 20 20 6e 75 6d 62 65 |, and.th|e numbe|
|000037d0| 72 20 20 6f 66 20 20 63 | 68 61 72 61 63 74 65 72 |r of c|haracter|
|000037e0| 73 20 20 74 6f 20 20 72 | 65 74 75 72 6e 2c 20 20 |s to r|eturn, |
|000037f0| 72 65 73 70 65 63 74 69 | 76 65 6c 79 2e 20 20 54 |respecti|vely. T|
|00003800| 68 65 20 73 79 6e 74 61 | 78 20 6f 66 20 74 68 69 |he synta|x of thi|
|00003810| 73 0d 65 78 70 72 65 73 | 73 69 6f 6e 20 69 73 20 |s.expres|sion is |
|00003820| 74 68 65 20 73 61 6d 65 | 20 77 68 65 74 68 65 72 |the same| whether|
|00003830| 20 79 6f 75 20 75 73 65 | 20 61 20 66 72 61 6d 65 | you use| a frame|
|00003840| 2c 20 20 61 73 20 77 69 | 74 68 20 4c 65 74 74 65 |, as wi|th Lette|
|00003850| 72 2c 20 6f 72 20 61 20 | 63 65 6c 6c 2c 0d 73 75 |r, or a |cell,.su|
|00003860| 63 68 20 61 73 20 44 61 | 74 61 62 61 73 65 2e 43 |ch as Da|tabase.C|
|00003870| 35 2c 20 20 6f 72 20 61 | 20 6c 6f 63 61 6c 20 76 |5, or a| local v|
|00003880| 61 72 69 61 62 6c 65 2e | 20 20 43 61 72 72 79 69 |ariable.| Carryi|
|00003890| 6e 67 20 74 68 69 73 20 | 61 20 6c 69 74 74 6c 65 |ng this |a little|
|000038a0| 20 66 75 72 74 68 65 72 | 2c 0d 77 65 20 63 6f 75 | further|,.we cou|
|000038b0| 6c 64 20 61 63 74 75 61 | 6c 6c 79 20 61 73 73 69 |ld actua|lly assi|
|000038c0| 67 6e 20 61 20 77 6f 72 | 64 20 66 72 61 6d 65 20 |gn a wor|d frame |
|000038d0| 6f 66 20 75 70 20 74 6f | 20 33 32 2c 30 30 30 20 |of up to| 32,000 |
|000038e0| 63 68 61 72 61 63 74 65 | 72 73 20 74 6f 20 61 20 |characte|rs to a |
|000038f0| 6c 6f 63 61 6c 0d 76 61 | 72 69 61 62 6c 65 20 6c |local.va|riable l|
|00003900| 69 6b 65 20 74 68 69 73 | 3a ff 02 00 4b ff 02 00 |ike this|:...K...|
|00003910| 4b 20 20 20 20 20 40 6c | 6f 63 61 6c 28 20 74 65 |K @l|ocal( te|
|00003920| 6d 70 20 29 2c 20 20 20 | 20 20 20 20 20 20 20 20 |mp ), | |
|00003930| 20 20 20 20 20 20 3b 20 | 49 6e 69 74 69 61 6c 69 | ; |Initiali|
|00003940| 7a 65 20 6c 6f 63 61 6c | 20 76 61 72 69 61 62 6c |ze local| variabl|
|00003950| 65 2e ff 02 00 4b 20 20 | 20 20 20 74 65 6d 70 20 |e....K | temp |
|00003960| 3a 3d 20 4c 65 74 74 65 | 72 2c 20 20 20 20 20 20 |:= Lette|r, |
|00003970| 20 20 20 20 20 20 20 20 | 20 20 3b 20 41 73 73 69 | | ; Assi|
|00003980| 67 6e 20 77 6f 72 64 20 | 66 72 61 6d 65 20 74 6f |gn word |frame to|
|00003990| 20 74 65 6d 70 2e ff 02 | 00 4b 20 20 20 20 20 54 | temp...|.K T|
|000039a0| 65 73 74 20 3a 3d 20 40 | 6d 69 64 28 20 74 65 6d |est := @|mid( tem|
|000039b0| 70 2c 20 32 30 30 2c 20 | 31 20 29 20 20 20 3b 20 |p, 200, |1 ) ; |
|000039c0| 54 65 73 74 20 66 72 61 | 6d 65 20 67 65 74 73 20 |Test fra|me gets |
|000039d0| 32 30 30 74 68 20 63 68 | 61 72 2e ff 02 00 4b ff |200th ch|ar....K.|
|000039e0| 02 00 4b 54 68 69 73 20 | 70 72 6f 64 75 63 65 73 |..KThis |produces|
|000039f0| 20 74 68 65 20 73 61 6d | 65 20 72 65 73 75 6c 74 | the sam|e result|
|00003a00| 73 20 61 73 20 62 65 66 | 6f 72 65 2c 20 20 62 75 |s as bef|ore, bu|
|00003a10| 74 20 79 6f 75 20 63 61 | 6e 20 73 65 65 20 20 74 |t you ca|n see t|
|00003a20| 68 61 74 20 6e 6f 20 73 | 70 65 63 69 61 6c 0d 66 |hat no s|pecial.f|
|00003a30| 75 6e 63 74 69 6f 6e 73 | 20 61 72 65 20 72 65 71 |unctions| are req|
|00003a40| 75 69 72 65 64 20 74 6f | 20 61 73 73 69 67 6e 20 |uired to| assign |
|00003a50| 74 68 65 20 77 6f 72 64 | 20 66 72 61 6d 65 20 74 |the word| frame t|
|00003a60| 6f 20 61 6e 79 20 6f 74 | 68 65 72 20 76 61 72 69 |o any ot|her vari|
|00003a70| 61 62 6c 65 2e 20 54 68 | 61 74 0d 69 73 20 65 6e |able. Th|at.is en|
|00003a80| 6f 75 67 68 20 6f 6e 20 | 73 74 6f 72 61 67 65 20 |ough on |storage |
|00003a90| 66 6f 72 20 74 68 65 20 | 74 69 6d 65 20 62 65 69 |for the |time bei|
|00003aa0| 6e 67 2e 20 20 20 4f 75 | 72 20 6e 65 78 74 20 73 |ng. Ou|r next s|
|00003ab0| 75 62 6a 65 63 74 20 63 | 6f 6e 72 6e 73 20 74 68 |ubject c|onrns th|
|00003ac0| 65 20 72 65 61 6c 0d 77 | 6f 72 6b 65 72 73 20 69 |e real.w|orkers i|
|00003ad0| 6e 20 46 52 45 44 3a 20 | 74 68 65 20 66 75 6e 63 |n FRED: |the func|
|00003ae0| 74 69 6f 6e 73 20 74 68 | 61 74 20 77 6f 72 6b 20 |tions th|at work |
|00003af0| 77 69 74 68 20 73 74 72 | 69 6e 67 73 20 61 6e 64 |with str|ings and|
|00003b00| 20 6e 75 6d 62 65 72 73 | 2e ff 02 00 4b ff 02 00 | numbers|....K...|
|00003b10| 4b ff 02 00 4b 57 6f 72 | 6b 69 6e 67 20 77 69 74 |K...KWor|king wit|
|00003b20| 68 20 56 61 6c 75 65 20 | 46 75 6e 63 74 69 6f 6e |h Value |Function|
|00003b30| 73 ff 02 00 4b ff 02 00 | 4b 49 66 20 20 73 6f 6d |s...K...|KIf som|
|00003b40| 65 6f 6e 65 20 61 73 6b | 65 64 20 6d 65 20 20 74 |eone ask|ed me t|
|00003b50| 6f 20 20 64 69 76 69 64 | 65 20 20 46 52 45 44 20 |o divid|e FRED |
|00003b60| 20 66 75 6e 63 74 69 6f | 6e 73 20 20 69 6e 74 6f | functio|ns into|
|00003b70| 20 20 67 65 6e 65 72 61 | 6c 20 20 67 72 6f 75 70 | genera|l group|
|00003b80| 73 20 62 79 0d 66 75 6e | 63 74 69 6f 6e 2c 20 20 |s by.fun|ction, |
|00003b90| 49 20 77 6f 75 6c 64 20 | 63 72 65 61 74 65 20 74 |I would |create t|
|00003ba0| 77 6f 20 73 75 63 68 20 | 67 72 6f 75 70 73 2e 20 |wo such |groups. |
|00003bb0| 20 54 68 65 20 66 69 72 | 73 74 20 67 72 6f 75 70 | The fir|st group|
|00003bc0| 20 63 6f 75 6c 64 20 62 | 65 20 63 61 6c 6c 65 64 | could b|e called|
|00003bd0| 0d 22 63 6f 6e 74 72 6f | 6c 22 20 20 66 75 6e 63 |."contro|l" func|
|00003be0| 74 69 6f 6e 73 2c 20 20 | 61 6e 64 20 20 77 6f 75 |tions, |and wou|
|00003bf0| 6c 64 20 69 6e 63 6c 75 | 64 65 20 20 74 68 65 20 |ld inclu|de the |
|00003c00| 20 66 75 6e 63 74 69 6f | 6e 73 20 20 75 73 65 64 | functio|ns used|
|00003c10| 20 20 74 6f 20 70 65 72 | 66 6f 72 6d 0d 6c 6f 6f | to per|form.loo|
|00003c20| 70 69 6e 67 2c 20 20 74 | 65 73 74 69 6e 67 2c 20 |ping, t|esting, |
|00003c30| 20 72 65 67 69 6f 6e 20 | 20 77 61 6c 6b 69 6e 67 | region | walking|
|00003c40| 2c 20 20 61 6e 64 20 20 | 69 6e 70 75 74 2f 6f 75 |, and |input/ou|
|00003c50| 74 70 75 74 2e 20 20 20 | 54 68 65 73 65 20 20 66 |tput. |These f|
|00003c60| 75 6e 63 74 69 6f 6e 73 | 0d 70 72 6f 76 69 64 65 |unctions|.provide|
|00003c70| 20 73 6f 6d 65 74 68 69 | 6e 67 20 6c 69 6b 65 20 | somethi|ng like |
|00003c80| 61 20 73 79 73 74 65 6d | 20 6f 66 20 74 72 61 66 |a system| of traf|
|00003c90| 66 69 63 20 6c 69 67 68 | 74 73 20 66 6f 72 20 79 |fic ligh|ts for y|
|00003ca0| 6f 75 72 20 20 70 72 6f | 67 72 61 6d 2c 20 6d 61 |our pro|gram, ma|
|00003cb0| 6b 69 6e 67 0d 74 68 65 | 20 64 65 63 69 73 69 6f |king.the| decisio|
|00003cc0| 6e 73 20 6f 6e 20 77 68 | 65 72 65 20 74 6f 20 67 |ns on wh|ere to g|
|00003cd0| 6f 20 61 6e 64 20 77 68 | 65 6e 20 74 6f 20 73 74 |o and wh|en to st|
|00003ce0| 6f 70 2e 20 20 20 54 68 | 65 72 65 20 61 72 65 20 |op. Th|ere are |
|00003cf0| 6d 61 6e 79 20 64 69 66 | 66 65 72 65 6e 63 65 73 |many dif|ferences|
|00003d00| 0d 61 6d 6f 6e 67 20 74 | 68 65 73 65 20 66 75 6e |.among t|hese fun|
|00003d10| 63 74 69 6f 6e 73 2c 20 | 73 6f 20 74 68 65 79 20 |ctions, |so they |
|00003d20| 77 69 6c 6c 20 62 65 20 | 63 6f 76 65 72 65 64 20 |will be |covered |
|00003d30| 73 65 70 61 72 61 74 65 | 6c 79 20 6c 61 74 65 72 |separate|ly later|
|00003d40| 20 6f 6e 2e ff 02 00 4b | ff 02 00 4b 54 68 65 20 | on....K|...KThe |
|00003d50| 73 65 63 6f 6e 64 20 67 | 72 6f 75 70 20 49 27 6c |second g|roup I'l|
|00003d60| 6c 20 63 61 6c 6c 20 74 | 68 65 20 22 76 61 6c 75 |l call t|he "valu|
|00003d70| 65 22 20 66 75 6e 63 74 | 69 6f 6e 73 2e 20 49 74 |e" funct|ions. It|
|00003d80| 20 69 6e 63 6c 75 64 65 | 73 20 74 68 65 20 66 75 | include|s the fu|
|00003d90| 6e 63 74 69 6f 6e 73 0d | 74 68 61 74 20 20 6f 70 |nctions.|that op|
|00003da0| 65 72 61 74 65 20 20 6f | 6e 20 20 73 74 72 69 6e |erate o|n strin|
|00003db0| 67 20 20 61 6e 64 20 20 | 6e 75 6d 65 72 69 63 20 |g and |numeric |
|00003dc0| 20 76 61 6c 75 65 73 2c | 20 20 73 75 63 68 20 20 | values,| such |
|00003dd0| 61 73 20 20 63 6f 6e 76 | 65 72 73 69 6f 6e 73 20 |as conv|ersions |
|00003de0| 61 6e 64 0d 63 61 6c 63 | 75 6c 61 74 69 6f 6e 73 |and.calc|ulations|
|00003df0| 2e 20 20 20 50 6c 65 61 | 73 65 20 6e 6f 74 65 20 |. Plea|se note |
|00003e00| 74 68 61 74 20 77 68 65 | 6e 20 49 20 75 73 65 20 |that whe|n I use |
|00003e10| 74 68 65 20 77 6f 72 64 | 20 22 76 61 6c 75 65 22 |the word| "value"|
|00003e20| 20 49 20 61 6d 20 72 65 | 66 65 72 72 69 6e 67 0d | I am re|ferring.|
|00003e30| 74 6f 20 6e 75 6d 65 72 | 69 63 20 61 6e 64 20 73 |to numer|ic and s|
|00003e40| 74 72 69 6e 67 20 76 61 | 6c 75 65 73 20 69 6e 20 |tring va|lues in |
|00003e50| 67 65 6e 65 72 61 6c 2e | ff 02 00 4b ff 02 00 4b |general.|...K...K|
|00003e60| 54 6f 20 62 65 67 69 6e | 20 6f 75 72 20 64 69 73 |To begin| our dis|
|00003e70| 63 75 73 73 69 6f 6e 20 | 6f 66 20 76 61 6c 75 65 |cussion |of value|
|00003e80| 20 66 75 6e 63 74 69 6f | 6e 73 2c 20 63 72 65 61 | functio|ns, crea|
|00003e90| 74 65 20 61 20 73 70 72 | 65 61 64 73 68 65 65 74 |te a spr|eadsheet|
|00003ea0| 20 74 68 61 74 20 6c 6f | 6f 6b 73 0d 6c 69 6b 65 | that lo|oks.like|
|00003eb0| 20 74 68 69 73 3a ff 02 | 00 4b ff 02 00 4b 5b 53 | this:..|.K...K[S|
|00003ec0| 61 6c 65 73 20 54 6f 74 | 61 6c 73 5d ff 02 00 4b |ales Tot|als]...K|
|00003ed0| 20 20 20 20 20 20 41 20 | 20 20 20 20 20 20 20 20 | A | |
|00003ee0| 20 20 20 42 20 20 20 20 | 20 20 20 20 43 20 20 20 | B | C |
|00003ef0| 20 20 20 20 20 20 44 20 | 20 20 20 20 20 45 ff 02 | D | E..|
|00003f00| 00 4b 20 31 20 20 20 20 | 20 20 20 20 20 20 20 20 |.K 1 | |
|00003f10| 20 20 20 53 61 6c 65 73 | 20 20 20 20 41 6d 6f 75 | Sales| Amou|
|00003f20| 6e 74 20 20 20 20 42 6f | 6e 75 73 ff 02 00 4b 20 |nt Bo|nus...K |
|00003f30| 32 20 53 6d 69 74 68 2c | 20 4a 2e 20 20 20 20 20 |2 Smith,| J. |
|00003f40| 20 20 33 20 20 20 20 20 | 20 20 33 30 30 30 20 20 | 3 | 3000 |
|00003f50| 20 20 20 20 33 30 ff 02 | 00 4b 20 33 20 4a 6f 6e | 30..|.K 3 Jon|
|00003f60| 65 73 2c 20 54 2e 20 20 | 20 20 20 20 20 34 20 20 |es, T. | 4 |
|00003f70| 20 20 20 20 20 36 30 30 | 30 20 20 20 20 20 20 36 | 600|0 6|
|00003f80| 30 ff 02 00 4b 20 34 20 | 41 73 68 74 6f 6e 2c 20 |0...K 4 |Ashton, |
|00003f90| 4d 2e 20 20 20 20 20 20 | 37 20 20 20 20 20 20 20 |M. |7 |
|00003fa0| 36 30 30 30 20 20 20 20 | 20 20 36 30 ff 02 00 4b |6000 | 60...K|
|00003fb0| 20 35 ff 02 00 4b 20 36 | ff 02 00 4b ff 02 00 4b | 5...K 6|...K...K|
|00003fc0| 4e 6f 77 20 69 73 20 61 | 73 20 67 6f 6f 64 20 61 |Now is a|s good a|
|00003fd0| 20 74 69 6d 65 20 61 73 | 20 61 6e 79 20 74 6f 20 | time as| any to |
|00003fe0| 64 69 73 63 75 73 73 20 | 72 65 67 69 6f 6e 73 2c |discuss |regions,|
|00003ff0| 20 20 77 68 69 63 68 20 | 70 6c 61 79 20 61 20 62 | which |play a b|
|00004000| 69 67 20 20 72 6f 6c 65 | 20 69 6e 0d 46 52 45 44 |ig role| in.FRED|
|00004010| 20 70 72 6f 67 72 61 6d | 6d 69 6e 67 2e 20 20 49 | program|ming. I|
|00004020| 66 20 79 6f 75 20 74 68 | 69 6e 6b 20 61 62 6f 75 |f you th|ink abou|
|00004030| 74 20 69 74 2c 20 74 68 | 65 20 74 68 69 6e 67 73 |t it, th|e things|
|00004040| 20 79 6f 75 20 61 72 65 | 20 6d 6f 73 74 20 6c 69 | you are| most li|
|00004050| 6b 65 6c 79 20 74 6f 0d | 64 6f 20 77 69 74 68 20 |kely to.|do with |
|00004060| 20 46 72 61 6d 65 77 6f | 72 6b 20 77 69 6c 6c 20 | Framewo|rk will |
|00004070| 20 69 6e 76 6f 6c 76 65 | 20 75 73 69 6e 67 20 67 | involve| using g|
|00004080| 72 6f 75 70 73 20 20 6f | 66 20 63 65 6c 6c 73 20 |roups o|f cells |
|00004090| 20 69 6e 20 73 70 72 65 | 61 64 73 68 65 65 74 73 | in spre|adsheets|
|000040a0| 20 6f 72 0d 64 61 74 61 | 62 61 73 65 73 2e 20 20 | or.data|bases. |
|000040b0| 20 41 20 72 65 67 69 6f | 6e 20 69 73 20 61 20 70 | A regio|n is a p|
|000040c0| 61 72 74 69 63 75 6c 61 | 72 20 67 72 6f 75 70 20 |articula|r group |
|000040d0| 6f 66 20 63 65 6c 6c 73 | 20 74 68 61 74 20 61 72 |of cells| that ar|
|000040e0| 65 20 74 6f 20 62 65 20 | 75 73 65 64 20 69 6e 0d |e to be |used in.|
|000040f0| 73 6f 6d 65 20 46 52 45 | 44 20 63 61 6c 63 75 6c |some FRE|D calcul|
|00004100| 61 74 69 6f 6e 2e 20 20 | 49 6e 20 74 68 65 20 73 |ation. |In the s|
|00004110| 61 6d 70 6c 65 20 73 70 | 72 65 61 64 73 68 65 62 |ample sp|readsheb|
|00004120| 6f 76 65 65 20 77 74 68 | 65 20 72 65 67 69 6f 6e |ovee wth|e region|
|00004130| 20 42 32 3a 42 34 20 74 | 6f ff 02 00 4b 72 65 66 | B2:B4 t|o...Kref|
|00004140| 65 72 20 74 6f 20 74 68 | 65 20 74 68 72 65 65 20 |er to th|e three |
|00004150| 6e 75 6d 62 65 72 73 20 | 69 6e 20 74 68 65 20 53 |numbers |in the S|
|00004160| 61 6c 65 73 20 63 6f 6c | 75 6d 6e 2e 20 20 41 73 |ales col|umn. As|
|00004170| 20 61 6e 20 69 6c 6c 75 | 73 74 72 61 74 69 6f 6e | an illu|stration|
|00004180| 2c 20 69 66 20 79 6f 75 | 0d 77 65 72 65 20 74 6f |, if you|.were to|
|00004190| 20 77 72 69 74 65 20 64 | 6f 77 6e 20 61 20 72 61 | write d|own a ra|
|000041a0| 6e 67 65 20 6f 66 20 70 | 61 67 65 20 6e 75 6d 62 |nge of p|age numb|
|000041b0| 65 72 73 20 74 68 61 74 | 20 79 6f 75 20 77 61 6e |ers that| you wan|
|000041c0| 74 65 64 20 74 6f 20 72 | 65 6d 65 6d 62 65 72 2c |ted to r|emember,|
|000041d0| 20 79 6f 75 0d 77 6f 75 | 6c 64 20 70 72 6f 62 61 | you.wou|ld proba|
|000041e0| 62 6c 79 20 77 72 69 74 | 65 20 22 70 70 2e 20 20 |bly writ|e "pp. |
|000041f0| 36 2d 31 37 2c 22 20 6d | 65 61 6e 69 6e 67 20 22 |6-17," m|eaning "|
|00004200| 70 61 67 65 73 20 73 69 | 78 20 74 68 72 6f 75 67 |pages si|x throug|
|00004210| 68 20 73 65 76 65 6e 74 | 65 65 6e 2e 22 ff 02 00 |h sevent|een."...|
|00004220| 4b ff 02 00 4b 54 68 65 | 20 63 6f 6e 63 65 70 74 |K...KThe| concept|
|00004230| 20 69 73 20 20 74 68 65 | 20 73 61 6d 65 20 20 77 | is the| same w|
|00004240| 69 74 68 20 20 61 20 72 | 65 67 69 6f 6e 20 20 69 |ith a r|egion i|
|00004250| 6e 20 20 46 52 45 44 2e | 20 20 20 42 32 3a 42 34 |n FRED.| B2:B4|
|00004260| 20 6d 65 61 6e 73 20 22 | 63 65 6c 6c 73 20 42 32 | means "|cells B2|
|00004270| 0d 74 68 72 6f 75 67 68 | 20 42 34 2c 22 20 20 61 |.through| B4," a|
|00004280| 6e 64 20 69 73 20 74 68 | 72 65 65 20 76 65 72 74 |nd is th|ree vert|
|00004290| 69 63 61 6c 20 63 65 6c | 6c 73 20 69 6e 20 63 6f |ical cel|ls in co|
|000042a0| 6c 75 6d 6e 20 42 2e 20 | 41 20 72 61 6e 67 65 20 |lumn B. |A range |
|000042b0| 6d 75 73 74 20 63 6f 6e | 74 61 69 6e 0d 6f 6e 6c |must con|tain.onl|
|000042c0| 79 20 20 61 64 6a 61 63 | 65 6e 74 20 63 65 6c 6c |y adjac|ent cell|
|000042d0| 73 2c 20 20 74 68 6f 75 | 67 68 20 74 68 65 79 20 |s, thou|gh they |
|000042e0| 6d 61 79 20 62 65 20 69 | 6e 20 20 61 20 72 6f 77 |may be i|n a row|
|000042f0| 20 6f 72 20 20 61 20 63 | 6f 6c 75 6d 6e 20 20 6f | or a c|olumn o|
|00004300| 72 20 65 76 65 6e 20 61 | 0d 72 65 63 74 61 6e 67 |r even a|.rectang|
|00004310| 75 6c 61 72 20 62 6c 6f | 63 6b 2e 20 20 20 54 6f |ular blo|ck. To|
|00004320| 20 20 73 70 65 63 69 66 | 79 20 20 61 20 20 62 6c | specif|y a bl|
|00004330| 6f 63 6b 20 20 6f 66 20 | 20 63 65 6c 6c 73 2c 20 |ock of | cells, |
|00004340| 20 75 73 65 20 20 74 77 | 6f 20 64 69 61 67 6f 6e | use tw|o diagon|
|00004350| 61 6c 6c 79 0d 6f 70 70 | 6f 73 69 74 65 20 63 6f |ally.opp|osite co|
|00004360| 72 6e 65 72 20 63 65 6c | 6c 73 2e 20 20 20 57 65 |rner cel|ls. We|
|00004370| 20 63 6f 75 6c 64 20 73 | 70 65 63 69 66 79 20 61 | could s|pecify a|
|00004380| 6c 6c 20 74 68 65 20 6e | 75 6d 62 65 72 73 20 69 |ll the n|umbers i|
|00004390| 6e 20 20 74 68 65 20 65 | 73 20 54 6f 74 61 6c 73 |n the e|s Totals|
|000043a0| 0d 73 70 72 65 61 64 73 | 68 65 65 74 20 77 69 74 |.spreads|heet wit|
|000043b0| 68 20 20 74 68 65 20 72 | 61 6e 67 65 20 42 32 3a |h the r|ange B2:|
|000043c0| 44 34 2c 20 20 75 73 69 | 6e 67 20 74 68 65 20 75 |D4, usi|ng the u|
|000043d0| 70 70 65 72 20 20 6c 65 | 66 74 20 20 61 6e 64 20 |pper le|ft and |
|000043e0| 20 6c 6f 77 65 72 20 72 | 69 67 68 74 0d 63 65 6c | lower r|ight.cel|
|000043f0| 6c 73 20 6f 66 20 20 74 | 68 65 20 62 6c 6f 63 6b |ls of t|he block|
|00004400| 2e 20 20 20 41 6e 79 20 | 72 65 66 65 72 65 6e 63 |. Any |referenc|
|00004410| 65 20 20 74 6f 20 74 68 | 69 73 20 73 70 72 65 61 |e to th|is sprea|
|00004420| 64 73 68 65 65 74 20 66 | 72 6f 6d 20 20 61 20 64 |dsheet f|rom a d|
|00004430| 69 66 66 65 72 65 6e 74 | 0d 66 72 61 6d 65 20 77 |ifferent|.frame w|
|00004440| 6f 75 6c 64 20 68 61 76 | 65 20 74 6f 20 75 73 65 |ould hav|e to use|
|00004450| 20 74 68 65 20 66 6f 72 | 6d 61 6c 20 72 65 67 69 | the for|mal regi|
|00004460| 6f 6e 20 72 65 66 65 72 | 65 6e 63 65 20 74 68 61 |on refer|ence tha|
|00004470| 74 20 69 6e 63 6c 75 64 | 65 73 20 74 68 65 20 66 |t includ|es the f|
|00004480| 72 61 6d 65 0d 6e 61 6d | 65 2c 20 73 75 63 68 20 |rame.nam|e, such |
|00004490| 61 73 20 53 61 6c 65 73 | 20 54 6f 74 61 6c 73 2e |as Sales| Totals.|
|000044a0| 42 32 3a 53 61 6c 65 73 | 20 54 6f 74 61 6c 73 2e |B2:Sales| Totals.|
|000044b0| 44 34 2e ff 02 00 4b ff | 02 00 4b 4c 65 74 27 73 |D4....K.|..KLet's|
|000044c0| 20 70 75 74 20 73 6f 6d | 65 20 66 75 6e 63 74 69 | put som|e functi|
|000044d0| 6f 6e 73 20 69 6e 20 74 | 68 69 73 20 73 70 72 65 |ons in t|his spre|
|000044e0| 61 64 73 68 65 65 74 20 | 74 6f 20 64 65 6d 6f 6e |adsheet |to demon|
|000044f0| 73 74 72 61 74 65 20 68 | 6f 77 20 20 74 68 65 79 |strate h|ow they|
|00004500| 20 77 6f 75 6c 64 0d 62 | 65 20 75 73 65 64 2e 20 | would.b|e used. |
|00004510| 20 20 4f 6e 65 20 6f 66 | 20 74 68 65 20 6d 6f 73 | One of| the mos|
|00004520| 74 20 63 6f 6d 6d 6f 6e | 20 69 73 20 40 73 75 6d |t common| is @sum|
|00004530| 2c 20 20 61 6e 64 20 69 | 74 20 77 69 6c 6c 20 77 |, and i|t will w|
|00004540| 6f 72 6b 20 6a 75 73 74 | 20 67 72 65 61 74 20 66 |ork just| great f|
|00004550| 6f 72 0d 75 73 20 77 68 | 65 6e 20 77 65 20 6e 65 |or.us wh|en we ne|
|00004560| 65 64 20 74 6f 20 63 61 | 6c 63 75 6c 61 74 65 20 |ed to ca|lculate |
|00004570| 74 68 65 20 74 6f 74 61 | 6c 73 20 66 6f 72 20 65 |the tota|ls for e|
|00004580| 61 63 68 20 63 6f 6c 75 | 6d 6e 2e 20 40 73 75 6d |ach colu|mn. @sum|
|00004590| 20 74 79 70 69 63 61 6c | 6c 79 20 68 61 73 0d 6f | typical|ly has.o|
|000045a0| 6e 65 20 61 72 67 75 6d | 65 6e 74 2c 20 61 20 72 |ne argum|ent, a r|
|000045b0| 65 67 69 6f 6e 20 72 65 | 66 65 72 65 6e 63 65 2e |egion re|ference.|
|000045c0| 20 20 49 6e 20 6f 75 72 | 20 63 61 73 65 2c 20 74 | In our| case, t|
|000045d0| 68 65 20 72 65 67 69 6f | 6e 20 69 73 20 61 20 63 |he regio|n is a c|
|000045e0| 6f 6c 75 6d 6e 2e 20 20 | 54 6f 0d 63 61 6c 63 75 |olumn. |To.calcu|
|000045f0| 6c 61 74 65 20 63 6f 6c | 75 6d 6e 20 74 6f 74 61 |late col|umn tota|
|00004600| 6c 73 20 66 6f 72 20 74 | 68 65 20 61 62 6f 76 65 |ls for t|he above|
|00004610| 20 73 70 72 65 61 64 73 | 68 65 65 74 2c 20 66 69 | spreads|heet, fi|
|00004620| 72 73 74 20 73 65 74 20 | 75 70 20 61 20 72 6f 77 |rst set |up a row|
|00004630| 20 74 69 74 6c 65 0d 62 | 79 20 6d 6f 76 69 6e 67 | title.b|y moving|
|00004640| 20 74 68 65 20 63 75 72 | 73 6f 72 20 20 74 6f 20 | the cur|sor to |
|00004650| 63 65 6c 6c 20 41 36 2e | 20 20 20 53 65 63 6f 6e |cell A6.| Secon|
|00004660| 64 2c 20 20 74 79 70 65 | 20 54 6f 74 61 6c 20 66 |d, type| Total f|
|00004670| 6f 6c 6c 6f 77 65 64 20 | 62 79 20 52 65 74 75 72 |ollowed |by Retur|
|00004680| 6e 2e 0d 54 68 69 72 64 | 2c 20 20 6d 6f 76 65 20 |n..Third|, move |
|00004690| 20 74 6f 20 20 63 65 6c | 6c 20 20 42 36 2c 20 20 | to cel|l B6, |
|000046a0| 70 72 65 73 73 20 45 44 | 49 54 20 46 4f 52 4d 55 |press ED|IT FORMU|
|000046b0| 4c 41 20 28 46 32 29 2c | 20 20 61 6e 64 20 74 79 |LA (F2),| and ty|
|000046c0| 70 65 20 40 73 75 6d 28 | 42 32 3a 42 34 29 0d 66 |pe @sum(|B2:B4).f|
|000046d0| 6f 6c 6c 6f 77 65 64 20 | 62 79 20 52 65 74 75 72 |ollowed |by Retur|
|000046e0| 6e 2e 20 20 20 54 68 65 | 20 74 6f 74 61 6c 20 77 |n. The| total w|
|000046f0| 69 6c 6c 20 61 70 70 65 | 61 72 20 69 6e 20 74 68 |ill appe|ar in th|
|00004700| 65 20 63 65 6c 6c 20 61 | 6c 6d 6f 73 74 20 69 6d |e cell a|lmost im|
|00004710| 6d 65 64 69 61 74 65 6c | 79 2e 0d 50 72 65 73 73 |mediatel|y..Press|
|00004720| 20 43 4f 50 59 20 20 28 | 46 38 29 2c 20 20 52 69 | COPY (|F8), Ri|
|00004730| 67 68 74 61 72 72 6f 77 | 2c 20 20 45 58 54 45 4e |ghtarrow|, EXTEN|
|00004740| 44 20 53 45 4c 45 43 54 | 20 28 46 36 29 2c 20 20 |D SELECT| (F6), |
|00004750| 52 69 67 68 74 61 72 72 | 6f 77 2c 20 61 6e 64 20 |Rightarr|ow, and |
|00004760| 52 65 74 75 72 6e 0d 74 | 77 69 63 65 20 74 6f 20 |Return.t|wice to |
|00004770| 73 65 65 20 74 68 65 20 | 6f 74 68 65 72 20 63 6f |see the |other co|
|00004780| 6c 75 6d 6e 73 20 74 6f | 74 61 6c 65 64 2e 20 20 |lumns to|taled. |
|00004790| 54 68 65 20 66 6f 72 6d | 75 6c 61 20 66 72 6f 6d |The form|ula from|
|000047a0| 20 42 36 20 69 73 20 63 | 6f 70 69 65 64 20 69 6e | B6 is c|opied in|
|000047b0| 74 6f 0d 43 36 20 20 61 | 6e 64 20 44 36 2c 20 65 |to.C6 a|nd D6, e|
|000047c0| 78 63 65 70 74 20 74 68 | 61 74 20 74 68 65 20 72 |xcept th|at the r|
|000047d0| 65 67 69 6f 6e 20 72 65 | 66 65 72 65 6e 63 65 20 |egion re|ference |
|000047e0| 68 61 73 20 62 65 65 6e | 20 61 75 74 6f 6d 61 74 |has been| automat|
|000047f0| 69 63 61 6c 6c 79 20 63 | 68 61 6e 67 65 64 0d 74 |ically c|hanged.t|
|00004800| 6f 20 62 65 20 61 70 70 | 72 6f 70 72 69 61 74 65 |o be app|ropriate|
|00004810| 20 66 6f 72 20 65 61 63 | 68 20 20 6f 66 20 20 74 | for eac|h of t|
|00004820| 68 65 20 6e 65 77 20 74 | 6f 74 61 6c 73 2e 20 20 |he new t|otals. |
|00004830| 20 49 66 20 79 6f 75 20 | 68 61 76 65 20 6e 6f 74 | If you |have not|
|00004840| 20 20 72 75 6e 20 69 6e | 74 6f 0d 74 68 61 74 20 | run in|to.that |
|00004850| 20 62 65 66 6f 72 65 2c | 20 20 69 74 20 69 73 20 | before,| it is |
|00004860| 20 63 61 6c 6c 65 64 20 | 20 72 65 6c 61 74 69 76 | called | relativ|
|00004870| 65 20 20 72 65 66 65 72 | 65 6e 63 69 6e 67 2c 20 |e refer|encing, |
|00004880| 20 61 6e 64 20 69 73 20 | 61 20 20 70 61 72 74 20 | and is |a part |
|00004890| 6f 66 20 74 68 65 0d 63 | 75 72 73 6f 72 2d 70 6f |of the.c|ursor-po|
|000048a0| 69 6e 74 69 6e 67 20 61 | 6e 64 20 43 4f 50 59 20 |inting a|nd COPY |
|000048b0| 20 28 46 38 29 20 20 63 | 6f 6d 6d 61 6e 64 73 20 | (F8) c|ommands |
|000048c0| 20 28 73 65 65 20 20 43 | 68 61 70 74 65 72 20 32 | (see C|hapter 2|
|000048d0| 30 20 20 6f 66 20 74 68 | 65 20 54 75 74 6f 72 69 |0 of th|e Tutori|
|000048e0| 61 6c 0d 4d 61 6e 75 61 | 6c 29 2e 20 20 20 46 6f |al.Manua|l). Fo|
|000048f0| 72 20 6f 75 72 20 70 75 | 72 70 6f 73 65 73 2c 20 |r our pu|rposes, |
|00004900| 20 49 20 6a 75 73 74 20 | 77 61 6e 74 20 79 6f 75 | I just |want you|
|00004910| 20 74 6f 20 6e 6f 74 69 | 63 65 20 74 68 65 20 75 | to noti|ce the u|
|00004920| 73 65 20 6f 66 20 74 68 | 65 20 40 73 75 6d 0d 66 |se of th|e @sum.f|
|00004930| 75 6e 63 74 69 6f 6e 2c | 20 20 62 65 63 61 75 73 |unction,| becaus|
|00004940| 65 20 6d 61 6e 79 20 6f | 66 20 20 74 68 65 20 46 |e many o|f the F|
|00004950| 52 45 44 20 76 61 6c 75 | 65 20 20 66 75 6e 63 74 |RED valu|e funct|
|00004960| 69 6f 6e 73 20 61 72 65 | 20 75 73 65 64 20 20 69 |ions are| used i|
|00004970| 6e 20 74 68 65 20 73 61 | 6d 65 0d 77 61 79 2e 20 |n the sa|me.way. |
|00004980| 20 20 47 6f 20 65 64 69 | 74 20 20 74 68 65 20 66 | Go edi|t the f|
|00004990| 6f 72 6d 75 6c 61 20 69 | 6e 20 20 42 36 2c 20 20 |ormula i|n B6, |
|000049a0| 63 68 61 6e 67 69 6e 67 | 20 74 68 65 20 40 73 75 |changing| the @su|
|000049b0| 6d 20 74 6f 20 6f 6e 65 | 20 6f 66 20 20 74 68 65 |m to one| of the|
|000049c0| 20 6f 74 68 65 72 0d 73 | 74 61 74 69 73 74 69 63 | other.s|tatistic|
|000049d0| 61 6c 20 66 75 6e 63 74 | 69 6f 6e 73 20 6c 69 6b |al funct|ions lik|
|000049e0| 65 20 20 40 61 76 67 2c | 20 20 40 63 6f 75 6e 74 |e @avg,| @count|
|000049f0| 2c 20 20 6f 72 20 40 6d | 61 78 20 28 73 65 65 20 |, or @m|ax (see |
|00004a00| 43 68 61 70 74 65 72 20 | 20 31 31 20 6f 66 20 74 |Chapter | 11 of t|
|00004a10| 68 65 0d 46 72 61 6d 65 | 77 6f 72 6b 20 52 65 66 |he.Frame|work Ref|
|00004a20| 65 72 65 6e 63 65 20 4d | 61 6e 75 61 6c 29 2c 20 |erence M|anual), |
|00004a30| 61 6e 64 20 67 65 74 20 | 74 68 65 20 66 65 65 6c |and get |the feel|
|00004a40| 20 6f 66 20 68 6f 77 20 | 74 68 65 79 20 77 6f 72 | of how |they wor|
|00004a50| 6b 2e ff 02 00 4b ff 02 | 00 4b 49 74 20 69 73 20 |k....K..|.KIt is |
|00004a60| 69 6d 70 6f 72 74 61 6e | 74 20 74 68 61 74 20 79 |importan|t that y|
|00004a70| 6f 75 20 75 6e 64 65 72 | 73 74 61 6e 64 20 68 6f |ou under|stand ho|
|00004a80| 77 20 20 74 6f 20 75 73 | 65 20 72 65 67 69 6f 6e |w to us|e region|
|00004a90| 20 72 65 66 65 72 65 6e | 63 65 73 20 20 77 69 74 | referen|ces wit|
|00004aa0| 68 69 6e 20 61 0d 66 75 | 6e 63 74 69 6f 6e 2c 20 |hin a.fu|nction, |
|00004ab0| 77 68 69 63 68 20 69 73 | 20 77 68 79 20 49 20 63 |which is| why I c|
|00004ac0| 68 6f 73 65 20 74 6f 20 | 64 69 73 63 75 73 73 20 |hose to |discuss |
|00004ad0| 74 68 65 6d 20 66 69 72 | 73 74 2e 20 20 4d 61 6e |them fir|st. Man|
|00004ae0| 79 20 6f 66 20 46 52 45 | 44 27 73 20 76 61 6c 75 |y of FRE|D's valu|
|00004af0| 65 0d 66 75 6e 63 74 69 | 6f 6e 73 20 61 72 65 20 |e.functi|ons are |
|00004b00| 73 69 6d 70 6c 65 20 61 | 6e 64 20 6f 6e 6c 79 20 |simple a|nd only |
|00004b10| 72 65 71 75 69 72 65 20 | 74 68 61 74 20 79 6f 75 |require |that you|
|00004b20| 20 72 65 61 64 20 74 68 | 65 20 6d 61 6e 75 61 6c | read th|e manual|
|00004b30| 73 20 74 6f 20 64 69 73 | 63 6f 76 65 72 0d 74 68 |s to dis|cover.th|
|00004b40| 65 20 70 72 6f 70 65 72 | 20 73 79 6e 74 61 78 2e |e proper| syntax.|
|00004b50| 20 20 20 55 73 69 6e 67 | 20 63 65 72 74 61 69 6e | Using| certain|
|00004b60| 20 6f 66 20 74 68 65 73 | 65 20 66 75 6e 63 74 69 | of thes|e functi|
|00004b70| 6f 6e 73 20 6d 61 79 20 | 72 65 71 75 69 72 65 20 |ons may |require |
|00004b80| 6b 6e 6f 77 6c 65 64 67 | 65 0d 6f 66 20 61 64 76 |knowledg|e.of adv|
|00004b90| 61 6e 63 65 64 20 20 6d | 61 74 68 65 6d 61 74 69 |anced m|athemati|
|00004ba0| 63 73 20 77 68 69 63 68 | 20 69 73 2c 20 20 6f 66 |cs which| is, of|
|00004bb0| 20 20 63 6f 75 72 73 65 | 2c 20 20 62 65 79 6f 6e | course|, beyon|
|00004bc0| 64 20 20 74 68 65 20 20 | 73 63 6f 70 65 20 20 6f |d the |scope o|
|00004bd0| 66 20 74 68 65 0d 6d 61 | 6e 75 61 6c 73 20 61 6e |f the.ma|nuals an|
|00004be0| 64 20 20 6f 66 20 74 68 | 69 73 20 61 72 74 69 63 |d of th|is artic|
|00004bf0| 6c 65 3b 20 20 62 75 74 | 20 74 68 65 20 61 76 65 |le; but| the ave|
|00004c00| 72 61 67 65 20 75 73 65 | 72 20 20 77 69 6c 6c 20 |rage use|r will |
|00004c10| 68 61 76 65 20 6e 6f 20 | 20 6e 65 65 64 20 66 6f |have no | need fo|
|00004c20| 72 0d 74 68 69 73 2e 20 | 20 4d 79 20 67 6f 61 6c |r.this. | My goal|
|00004c30| 20 69 73 20 74 6f 20 67 | 69 76 65 20 79 6f 75 20 | is to g|ive you |
|00004c40| 61 6e 20 75 6e 64 65 72 | 73 74 61 6e 64 69 6e 67 |an under|standing|
|00004c50| 20 6f 66 20 68 6f 77 20 | 74 6f 20 75 73 65 20 66 | of how |to use f|
|00004c60| 75 6e 63 74 69 6f 6e 73 | 20 69 6e ff 02 00 4b 67 |unctions| in...Kg|
|00004c70| 65 6e 65 72 61 6c 2c 20 | 20 61 6e 64 20 68 6f 77 |eneral, | and how|
|00004c80| 20 74 6f 20 75 73 65 20 | 79 6f 75 72 20 6f 77 6e | to use |your own|
|00004c90| 20 63 72 65 61 74 69 76 | 69 74 79 20 20 74 6f 20 | creativ|ity to |
|00004ca0| 66 69 6e 64 20 74 68 65 | 20 73 6f 6c 75 74 69 6f |find the| solutio|
|00004cb0| 6e 73 20 20 74 6f 20 61 | 6e 79 0d 70 75 7a 7a 6c |ns to a|ny.puzzl|
|00004cc0| 65 73 20 79 6f 75 20 6d | 61 79 20 65 6e 63 6f 75 |es you m|ay encou|
|00004cd0| 6e 74 65 72 2e 20 20 42 | 65 63 61 75 73 65 20 74 |nter. B|ecause t|
|00004ce0| 68 65 79 20 61 72 65 20 | 6d 75 63 68 20 6c 69 6b |hey are |much lik|
|00004cf0| 65 20 73 74 61 6e 64 61 | 72 64 20 73 70 72 65 61 |e standa|rd sprea|
|00004d00| 64 73 68 65 65 74 0d 66 | 75 6e 63 74 69 6f 6e 73 |dsheet.f|unctions|
|00004d10| 20 61 6e 64 20 73 6f 6d | 65 77 68 61 74 20 73 65 | and som|ewhat se|
|00004d20| 6c 66 2d 65 78 70 6c 61 | 6e 61 74 6f 72 79 2c 20 |lf-expla|natory, |
|00004d30| 49 20 77 69 6c 6c 20 6c | 65 74 20 79 6f 75 20 65 |I will l|et you e|
|00004d40| 78 70 6c 6f 72 65 20 6d | 6f 73 74 20 6f 66 20 74 |xplore m|ost of t|
|00004d50| 68 65 0d 6e 75 6d 65 72 | 69 63 20 66 75 6e 63 74 |he.numer|ic funct|
|00004d60| 69 6f 6e 73 20 28 6c 69 | 6b 65 20 40 61 62 73 2c |ions (li|ke @abs,|
|00004d70| 20 20 40 65 78 70 2c 20 | 20 40 72 6f 75 6e 64 2c | @exp, | @round,|
|00004d80| 20 20 61 6e 64 20 40 69 | 6e 74 29 20 6f 6e 20 79 | and @i|nt) on y|
|00004d90| 6f 75 72 20 6f 77 6e 20 | 61 6e 64 20 77 65 0d 77 |our own |and we.w|
|00004da0| 69 6c 6c 20 6d 6f 76 65 | 20 6f 6e 20 74 6f 20 73 |ill move| on to s|
|00004db0| 74 72 69 6e 67 20 66 75 | 6e 63 74 69 6f 6e 73 2e |tring fu|nctions.|
|00004dc0| ff 02 00 ff ff 02 00 4b | 41 20 20 73 70 72 65 61 |.......K|A sprea|
|00004dd0| 64 73 68 65 65 74 20 77 | 61 73 20 63 6f 6e 76 65 |dsheet w|as conve|
|00004de0| 6e 69 65 6e 74 20 20 66 | 6f 72 20 64 69 73 63 75 |nient f|or discu|
|00004df0| 73 73 69 6e 67 20 20 66 | 75 6e 63 74 69 6f 6e 73 |ssing f|unctions|
|00004e00| 20 6c 69 6b 65 20 20 40 | 73 75 6d 20 62 65 63 61 | like @|sum beca|
|00004e10| 75 73 65 0d 73 70 72 65 | 61 64 73 68 65 65 74 73 |use.spre|adsheets|
|00004e20| 20 20 61 72 65 20 20 64 | 65 73 69 67 6e 65 64 20 | are d|esigned |
|00004e30| 20 74 6f 20 20 6d 61 6e | 69 70 75 6c 61 74 65 20 | to man|ipulate |
|00004e40| 20 6e 75 6d 62 65 72 73 | 2e 20 20 20 44 61 74 61 | numbers|. Data|
|00004e50| 62 61 73 65 73 2c 20 68 | 6f 77 65 76 65 72 2c 0d |bases, h|owever,.|
|00004e60| 75 73 75 61 6c 6c 79 20 | 20 68 61 6e 64 6c 65 20 |usually | handle |
|00004e70| 20 63 68 61 72 61 63 74 | 65 72 20 64 61 74 61 20 | charact|er data |
|00004e80| 20 28 73 74 72 69 6e 67 | 73 29 20 20 61 6e 64 20 | (string|s) and |
|00004e90| 20 77 65 20 20 77 69 6c | 6c 20 20 75 73 65 20 20 | we wil|l use |
|00004ea0| 6f 6e 65 20 20 6e 6f 77 | 20 74 6f 0d 64 65 6d 6f |one now| to.demo|
|00004eb0| 6e 73 74 72 61 74 65 20 | 20 73 74 72 69 6e 67 20 |nstrate | string |
|00004ec0| 20 66 75 6e 63 74 69 6f | 6e 73 2e 20 20 20 48 65 | functio|ns. He|
|00004ed0| 72 65 20 20 69 73 20 20 | 74 68 65 20 20 73 74 72 |re is |the str|
|00004ee0| 75 63 74 75 72 65 20 20 | 6f 66 20 20 6f 75 72 20 |ucture |of our |
|00004ef0| 65 78 61 6d 70 6c 65 0d | 64 61 74 61 62 61 73 65 |example.|database|
|00004f00| 3a ff 02 00 4b ff 02 00 | 4b 5b 44 61 74 61 62 61 |:...K...|K[Databa|
|00004f10| 73 65 5d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |se]-----|--------|
|00004f20| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00004f30| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00004f40| 2d 2d 2d 2d 2d 2d 2d 2d | 2d ff 02 00 4b 7c 20 4c |--------|-...K| L|
|00004f50| 61 73 74 20 20 20 46 69 | 72 73 74 20 20 20 54 69 |ast Fi|rst Ti|
|00004f60| 74 6c 65 20 20 41 64 64 | 72 65 73 73 20 20 20 20 |tle Add|ress |
|00004f70| 43 69 74 79 20 20 20 20 | 53 74 61 74 65 20 20 20 |City |State |
|00004f80| 20 5a 69 70 20 20 4c 61 | 62 65 6c 20 7c ff 02 00 | Zip La|bel |...|
|00004f90| 4b 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |K-------|--------|
|00004fa0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00004fb0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00004fc0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00004fd0| 2d ff 02 00 4b 7c 53 6d | 69 74 68 20 20 20 20 4a |-...K|Sm|ith J|
|00004fe0| 6f 65 20 20 20 20 20 44 | 72 2e 20 20 20 31 32 20 |oe D|r. 12 |
|00004ff0| 45 61 73 74 20 20 20 20 | 50 65 71 75 6f 74 20 20 |East |Pequot |
|00005000| 20 43 41 20 20 20 20 20 | 39 31 32 30 34 20 20 20 | CA |91204 |
|00005010| 20 20 20 20 7c ff 02 00 | 4b 7c 5f 5f 5f 5f 5f 5f | |...|K|______|
|00005020| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00005030| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00005040| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00005050| 5f 5f 5f 5f 5f 5f 5f 5f | 7c ff 02 00 4b ff 02 00 |________||...K...|
|00005060| 4b ff 02 00 4b 49 20 61 | 6d 20 67 6f 69 6e 67 20 |K...KI a|m going |
|00005070| 74 6f 20 62 65 20 6d 65 | 61 6e 20 68 65 72 65 2c |to be me|an here,|
|00005080| 20 20 61 6e 64 20 6e 6f | 74 20 74 65 6c 6c 20 79 | and no|t tell y|
|00005090| 6f 75 20 68 6f 77 20 74 | 6f 20 20 63 72 65 61 74 |ou how t|o creat|
|000050a0| 65 20 20 74 68 61 74 20 | 64 61 74 61 62 61 73 65 |e that |database|
|000050b0| 0d 66 72 61 6d 65 2e 20 | 20 20 49 66 20 79 6f 75 |.frame. | If you|
|000050c0| 20 68 61 76 65 20 63 6f | 6d 70 6c 65 74 65 64 20 | have co|mpleted |
|000050d0| 74 68 65 20 46 72 61 6d | 65 77 6f 72 6b 20 54 75 |the Fram|ework Tu|
|000050e0| 74 6f 72 69 61 6c 20 4d | 61 6e 75 61 6c 2c 20 79 |torial M|anual, y|
|000050f0| 6f 75 20 77 69 6c 6c 20 | 68 61 76 65 0d 6e 6f 20 |ou will |have.no |
|00005100| 70 72 6f 62 6c 65 6d 20 | 64 6f 69 6e 67 20 69 74 |problem |doing it|
|00005110| 2e 20 20 20 4a 75 73 74 | 20 73 65 74 20 75 70 20 |. Just| set up |
|00005120| 74 68 65 20 64 61 74 61 | 62 61 73 65 20 77 69 74 |the data|base wit|
|00005130| 68 20 74 68 65 20 73 74 | 72 75 63 74 75 72 65 20 |h the st|ructure |
|00005140| 61 6e 64 20 64 61 74 61 | 0d 73 68 6f 77 6e 20 61 |and data|.shown a|
|00005150| 62 6f 76 65 2e 20 20 57 | 68 61 74 20 77 65 20 77 |bove. W|hat we w|
|00005160| 61 6e 74 20 74 6f 20 64 | 6f 20 68 65 72 65 20 69 |ant to d|o here i|
|00005170| 73 20 74 6f 20 63 72 65 | 61 74 65 20 61 20 66 69 |s to cre|ate a fi|
|00005180| 65 6c 64 20 74 68 61 74 | 20 63 61 6e 20 62 65 20 |eld that| can be |
|00005190| 75 73 65 64 0d 74 6f 20 | 20 70 72 69 6e 74 20 6d |used.to | print m|
|000051a0| 61 69 6c 69 6e 67 20 6c | 61 62 65 6c 73 2e 20 20 |ailing l|abels. |
|000051b0| 20 42 79 20 20 70 6c 61 | 63 69 6e 67 20 74 68 65 | By pla|cing the|
|000051c0| 20 63 6f 72 72 65 63 74 | 20 20 66 6f 72 6d 75 6c | correct| formul|
|000051d0| 61 20 20 69 6e 20 20 74 | 68 65 20 4c 61 62 65 6c |a in t|he Label|
|000051e0| 0d 66 69 65 6c 64 2c 20 | 20 77 65 20 63 61 6e 20 |.field, | we can |
|000051f0| 63 6f 6d 62 69 6e 65 20 | 61 6c 6c 20 74 68 65 20 |combine |all the |
|00005200| 6f 74 68 65 72 20 66 69 | 65 6c 64 73 20 69 6e 74 |other fi|elds int|
|00005210| 6f 20 20 61 20 6c 61 62 | 65 6c 20 66 6f 72 6d 61 |o a lab|el forma|
|00005220| 74 20 20 61 6e 64 20 73 | 74 6f 72 65 0d 74 68 65 |t and s|tore.the|
|00005230| 20 72 65 73 75 6c 74 20 | 69 6e 20 74 68 65 20 4c | result |in the L|
|00005240| 61 62 65 6c 20 66 69 65 | 6c 64 2e 20 20 20 47 65 |abel fie|ld. Ge|
|00005250| 74 20 69 6e 74 6f 20 74 | 68 65 20 64 61 74 61 62 |t into t|he datab|
|00005260| 61 73 65 20 61 6e 64 20 | 70 6c 61 63 65 20 74 68 |ase and |place th|
|00005270| 65 20 63 75 72 73 6f 72 | 0d 6f 6e 20 74 68 65 20 |e cursor|.on the |
|00005280| 4c 61 62 65 6c 20 66 69 | 65 6c 64 2e 20 20 20 4e |Label fi|eld. N|
|00005290| 6f 77 20 70 72 65 73 73 | 20 46 4f 52 4d 55 4c 41 |ow press| FORMULA|
|000052a0| 20 45 44 49 54 20 28 46 | 32 29 20 61 6e 64 20 5a | EDIT (F|2) and Z|
|000052b0| 4f 4f 4d 20 28 46 39 29 | 20 74 6f 20 65 64 69 74 |OOM (F9)| to edit|
|000052c0| 20 74 68 65 0d 4c 61 62 | 65 6c 20 66 69 65 6c 64 | the.Lab|el field|
|000052d0| 20 66 6f 72 6d 75 6c 61 | 2e 20 20 45 6e 74 65 72 | formula|. Enter|
|000052e0| 20 74 68 69 73 20 66 6f | 72 6d 75 6c 61 3a ff 02 | this fo|rmula:..|
|000052f0| 00 4b ff 02 00 4b 20 20 | 20 20 20 4c 61 62 65 6c |.K...K | Label|
|00005300| 20 3a 3d 20 54 69 74 6c | 65 20 26 20 22 20 22 20 | := Titl|e & " " |
|00005310| 26 ff 02 00 4b 20 20 20 | 20 20 20 20 20 20 20 20 |&...K | |
|00005320| 20 20 20 46 69 72 73 74 | 20 26 20 22 20 22 20 26 | First| & " " &|
|00005330| ff 02 00 4b 20 20 20 20 | 20 20 20 20 20 20 20 20 |...K | |
|00005340| 20 20 4c 61 73 74 20 20 | 26 20 22 20 22 20 26 20 | Last |& " " & |
|00005350| 40 63 68 72 28 31 33 29 | 20 26 ff 02 00 4b 20 20 |@chr(13)| &...K |
|00005360| 20 20 20 20 20 20 20 20 | 20 20 20 20 41 64 64 72 | | Addr|
|00005370| 65 73 73 20 20 20 20 20 | 26 20 40 63 68 72 28 31 |ess |& @chr(1|
|00005380| 33 29 20 26 ff 02 00 4b | 20 20 20 20 20 20 20 20 |3) &...K| |
|00005390| 20 20 20 20 20 20 43 69 | 74 79 20 20 20 20 20 20 | Ci|ty |
|000053a0| 20 20 26 20 22 2c 20 22 | 20 26 ff 02 00 4b 20 20 | & ", "| &...K |
|000053b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 53 74 61 74 | | Stat|
|000053c0| 65 20 26 20 22 20 22 20 | 26 20 5a 69 70 ff 02 00 |e & " " |& Zip...|
|000053d0| 4b ff 02 00 4b 50 72 65 | 73 73 20 45 73 63 20 77 |K...KPre|ss Esc w|
|000053e0| 68 65 6e 20 79 6f 75 20 | 61 72 65 20 64 6f 6e 65 |hen you |are done|
|000053f0| 2e 20 20 20 54 6f 20 73 | 65 65 20 74 68 65 20 72 |. To s|ee the r|
|00005400| 65 73 75 6c 74 20 6f 66 | 20 74 68 69 73 20 20 66 |esult of| this f|
|00005410| 6f 72 6d 75 6c 61 2c 20 | 6d 6f 76 65 20 74 68 65 |ormula, |move the|
|00005420| 0d 63 75 72 73 6f 72 20 | 64 6f 77 6e 20 74 6f 20 |.cursor |down to |
|00005430| 74 68 65 20 6f 6e 65 20 | 72 65 63 6f 72 64 20 79 |the one |record y|
|00005440| 6f 75 20 68 61 64 20 65 | 6e 74 65 72 65 64 20 61 |ou had e|ntered a|
|00005450| 6e 64 20 70 72 65 73 73 | 20 52 45 43 41 4c 43 20 |nd press| RECALC |
|00005460| 20 28 46 35 29 20 6f 6e | 20 74 68 65 0d 4c 61 62 | (F5) on| the.Lab|
|00005470| 65 6c 20 66 69 65 6c 64 | 2e 20 20 20 59 6f 75 20 |el field|. You |
|00005480| 77 69 6c 6c 20 73 65 65 | 20 73 6f 6d 65 20 6f 66 |will see| some of|
|00005490| 20 74 68 65 20 69 6e 66 | 6f 72 6d 61 74 69 6f 6e | the inf|ormation|
|000054a0| 20 61 70 70 65 61 72 2c | 20 20 62 75 74 20 62 79 | appear,| but by|
|000054b0| 20 6e 6f 77 20 79 6f 75 | 0d 70 72 6f 62 61 62 6c | now you|.probabl|
|000054c0| 79 20 72 65 61 6c 69 7a | 65 20 74 68 61 74 20 6f |y realiz|e that o|
|000054d0| 6e 6c 79 20 6f 6e 65 20 | 6c 69 6e 65 20 6f 66 20 |nly one |line of |
|000054e0| 64 61 74 61 20 63 61 6e | 20 62 65 20 73 65 65 6e |data can| be seen|
|000054f0| 20 69 6e 20 61 20 64 61 | 74 61 62 61 73 65 20 66 | in a da|tabase f|
|00005500| 69 65 6c 64 0d 75 6e 6c | 65 73 73 20 79 6f 75 20 |ield.unl|ess you |
|00005510| 7a 6f 6f 6d 20 6f 6e 20 | 69 74 2e 20 20 53 6f 20 |zoom on |it. So |
|00005520| 70 72 65 73 73 20 74 68 | 65 20 73 70 61 63 65 62 |press th|e spaceb|
|00005530| 61 72 20 61 6e 64 20 74 | 68 65 6e 20 5a 4f 4f 4d |ar and t|hen ZOOM|
|00005540| 20 28 46 39 29 20 74 6f | 20 65 78 61 6d 69 6e 65 | (F9) to| examine|
|00005550| 0d 74 68 69 73 20 66 69 | 65 6c 64 2e 20 20 20 57 |.this fi|eld. W|
|00005560| 68 61 74 20 64 6f 20 79 | 6f 75 20 73 65 65 3f 20 |hat do y|ou see? |
|00005570| 20 41 20 74 68 72 65 65 | 2d 6c 69 6e 65 20 61 64 | A three|-line ad|
|00005580| 64 72 65 73 73 20 74 68 | 61 74 20 77 6f 75 6c 64 |dress th|at would|
|00005590| 20 66 69 74 20 6f 6e 20 | 6d 6f 73 74 0d 6c 61 62 | fit on |most.lab|
|000055a0| 65 6c 73 2c 20 72 69 67 | 68 74 3f 20 4c 65 74 20 |els, rig|ht? Let |
|000055b0| 75 73 20 65 78 61 6d 69 | 6e 65 20 74 68 65 20 66 |us exami|ne the f|
|000055c0| 6f 72 6d 75 6c 61 20 74 | 68 61 74 20 64 69 64 20 |ormula t|hat did |
|000055d0| 69 74 2e ff 02 00 4b ff | 02 00 4b 46 69 72 73 74 |it....K.|..KFirst|
|000055e0| 2c 20 20 77 65 20 68 61 | 76 65 20 74 68 65 20 66 |, we ha|ve the f|
|000055f0| 69 65 6c 64 20 6e 61 6d | 65 2c 20 20 4c 61 62 65 |ield nam|e, Labe|
|00005600| 6c 2c 20 20 61 6e 64 20 | 61 6e 20 61 73 73 69 67 |l, and |an assig|
|00005610| 6e 6d 65 6e 74 20 20 6f | 70 65 72 61 74 6f 72 2e |nment o|perator.|
|00005620| 20 20 54 68 69 73 0d 69 | 6e 64 69 63 61 74 65 73 | This.i|ndicates|
|00005630| 20 74 68 61 74 20 61 20 | 76 61 6c 75 65 20 20 69 | that a |value i|
|00005640| 73 20 62 65 69 6e 67 20 | 61 73 73 69 67 6e 65 64 |s being |assigned|
|00005650| 20 74 6f 20 20 74 68 61 | 74 20 66 69 65 6c 64 2e | to tha|t field.|
|00005660| 20 20 20 4e 6f 74 65 20 | 74 68 61 74 20 74 68 65 | Note |that the|
|00005670| 72 65 0d 61 72 65 20 6e | 6f 20 63 6f 6d 6d 61 73 |re.are n|o commas|
|00005680| 20 69 6e 20 74 68 65 20 | 66 6f 72 6d 75 6c 61 2c | in the |formula,|
|00005690| 20 20 61 6e 64 20 74 68 | 61 74 20 69 74 20 20 69 | and th|at it i|
|000056a0| 73 20 72 65 61 6c 6c 79 | 20 63 6f 6e 73 69 64 65 |s really| conside|
|000056b0| 72 65 64 20 20 74 6f 20 | 62 65 20 6f 6e 65 0d 66 |red to |be one.f|
|000056c0| 75 6e 63 74 69 6f 6e 2e | 20 20 20 54 68 65 20 6e |unction.| The n|
|000056d0| 65 61 74 6c 79 20 6f 72 | 64 65 72 65 64 20 66 6f |eatly or|dered fo|
|000056e0| 72 6d 61 74 2c 20 20 77 | 69 74 68 20 66 69 65 6c |rmat, w|ith fiel|
|000056f0| 64 73 20 61 6e 64 20 61 | 6d 70 65 72 73 61 6e 64 |ds and a|mpersand|
|00005700| 73 20 6c 69 6e 65 64 20 | 75 70 0d 75 6e 64 65 72 |s lined |up.under|
|00005710| 20 65 61 63 68 20 20 6f | 74 68 65 72 2c 20 20 64 | each o|ther, d|
|00005720| 65 6d 6f 6e 73 74 72 61 | 74 65 73 20 74 68 61 74 |emonstra|tes that|
|00005730| 20 46 52 45 44 20 69 67 | 6e 6f 72 65 73 20 73 70 | FRED ig|nores sp|
|00005740| 61 63 65 73 20 61 6e 64 | 20 20 52 65 74 75 72 6e |aces and| Return|
|00005750| 73 2e 20 59 6f 75 0d 63 | 61 6e 20 66 6f 72 6d 61 |s. You.c|an forma|
|00005760| 74 20 61 20 70 72 6f 67 | 72 61 6d 20 74 6f 20 62 |t a prog|ram to b|
|00005770| 65 20 65 61 73 69 6c 79 | 20 72 65 61 64 61 62 6c |e easily| readabl|
|00005780| 65 20 74 6f 20 79 6f 75 | 2c 20 61 6e 64 20 6e 6f |e to you|, and no|
|00005790| 74 20 77 6f 72 72 79 20 | 61 62 6f 75 74 ff 02 00 |t worry |about...|
|000057a0| 4b 61 66 66 65 63 74 69 | 6e 67 20 74 68 65 20 70 |Kaffecti|ng the p|
|000057b0| 72 6f 67 72 61 6d 27 73 | 20 6f 70 65 72 61 74 69 |rogram's| operati|
|000057c0| 6f 6e 2e ff 02 00 4b ff | 02 00 4b 4e 65 78 74 2c |on....K.|..KNext,|
|000057d0| 20 20 77 65 20 68 61 76 | 65 20 74 68 65 20 65 78 | we hav|e the ex|
|000057e0| 70 72 65 73 73 69 6f 6e | 20 74 68 61 74 20 63 72 |pression| that cr|
|000057f0| 65 61 74 65 73 20 20 6f | 75 72 20 6c 61 62 65 6c |eates o|ur label|
|00005800| 20 73 74 72 69 6e 67 2e | 20 20 20 59 6f 75 20 63 | string.| You c|
|00005810| 61 6e 20 73 65 65 0d 65 | 61 63 68 20 6f 66 20 74 |an see.e|ach of t|
|00005820| 68 65 20 66 69 65 6c 64 | 20 6e 61 6d 65 73 20 6c |he field| names l|
|00005830| 69 73 74 65 64 20 74 68 | 65 72 65 2c 20 61 73 20 |isted th|ere, as |
|00005840| 77 65 6c 6c 20 61 73 20 | 61 20 62 75 6e 63 68 20 |well as |a bunch |
|00005850| 6f 66 20 61 6d 70 65 72 | 73 61 6e 64 73 20 28 26 |of amper|sands (&|
|00005860| 29 2e 0d 54 68 65 20 61 | 6d 70 65 72 73 61 6e 64 |)..The a|mpersand|
|00005870| 20 63 68 61 72 61 63 74 | 65 72 20 69 73 20 20 63 | charact|er is c|
|00005880| 61 6c 6c 65 64 20 20 74 | 68 65 20 22 73 74 72 69 |alled t|he "stri|
|00005890| 6e 67 20 20 63 6f 6e 63 | 61 74 65 6e 61 74 6f 72 |ng conc|atenator|
|000058a0| 22 20 20 77 68 69 63 68 | 20 6d 65 61 6e 73 0d 74 |" which| means.t|
|000058b0| 68 61 74 20 69 74 20 63 | 61 6e 20 6a 6f 69 6e 20 |hat it c|an join |
|000058c0| 74 77 6f 20 73 74 72 69 | 6e 67 73 20 74 6f 67 65 |two stri|ngs toge|
|000058d0| 74 68 65 72 20 74 6f 20 | 6d 61 6b 65 20 61 20 6c |ther to |make a l|
|000058e0| 61 72 67 65 72 20 6f 6e | 65 2e 20 20 41 73 20 61 |arger on|e. As a|
|000058f0| 6e 20 65 78 61 6d 70 6c | 65 2c 0d 22 61 62 63 22 |n exampl|e,."abc"|
|00005900| 20 26 20 22 64 65 66 22 | 20 77 6f 75 6c 64 20 70 | & "def"| would p|
|00005910| 72 6f 64 75 63 65 20 74 | 68 65 20 73 74 72 69 6e |roduce t|he strin|
|00005920| 67 20 22 61 62 63 64 65 | 66 22 2e 20 53 6f 20 6f |g "abcde|f". So o|
|00005930| 75 72 20 66 6f 72 6d 75 | 6c 61 20 73 74 61 72 74 |ur formu|la start|
|00005940| 73 20 77 69 74 68 0d 61 | 20 70 65 72 73 6f 6e 27 |s with.a| person'|
|00005950| 73 20 54 69 74 6c 65 2c | 20 20 61 64 64 73 20 61 |s Title,| adds a|
|00005960| 20 73 70 61 63 65 2c 20 | 61 64 64 73 20 74 68 65 | space, |adds the|
|00005970| 20 66 69 72 73 74 20 6e | 61 6d 65 20 61 6e 64 20 | first n|ame and |
|00005980| 61 20 73 70 61 63 65 2c | 20 74 68 65 6e 20 61 64 |a space,| then ad|
|00005990| 64 73 0d 74 68 65 20 6c | 61 73 74 20 20 6e 61 6d |ds.the l|ast nam|
|000059a0| 65 2c 20 20 61 20 20 73 | 70 61 63 65 20 61 6e 64 |e, a s|pace and|
|000059b0| 20 40 63 68 72 28 31 33 | 29 2e 20 20 20 48 65 72 | @chr(13|). Her|
|000059c0| 65 20 20 77 65 20 20 6d | 65 65 74 20 20 6f 75 72 |e we m|eet our|
|000059d0| 20 20 66 69 72 73 74 20 | 73 74 72 69 6e 67 0d 66 | first |string.f|
|000059e0| 75 6e 63 74 69 6f 6e 2e | 20 20 40 63 68 72 20 77 |unction.| @chr w|
|000059f0| 69 6c 6c 20 70 72 6f 64 | 75 63 65 20 61 20 6f 6e |ill prod|uce a on|
|00005a00| 65 2d 63 68 61 72 61 63 | 74 65 72 20 73 74 72 69 |e-charac|ter stri|
|00005a10| 6e 67 20 66 72 6f 6d 20 | 74 68 65 20 41 53 43 49 |ng from |the ASCI|
|00005a20| 49 20 76 61 6c 75 65 20 | 69 6e 0d 74 68 65 20 70 |I value |in.the p|
|00005a30| 61 72 65 6e 74 68 65 73 | 65 73 2e 20 20 20 40 63 |arenthes|es. @c|
|00005a40| 68 72 28 31 33 29 20 20 | 70 75 74 73 20 61 20 52 |hr(13) |puts a R|
|00005a50| 65 74 75 72 6e 20 63 68 | 61 72 61 63 74 65 72 20 |eturn ch|aracter |
|00005a60| 69 6e 74 6f 20 6f 75 72 | 20 6c 61 62 65 6c 20 62 |into our| label b|
|00005a70| 65 63 61 75 73 65 0d 31 | 33 20 20 69 73 20 20 74 |ecause.1|3 is t|
|00005a80| 68 65 20 41 53 43 49 49 | 20 63 6f 64 65 20 20 66 |he ASCII| code f|
|00005a90| 6f 72 20 61 20 52 65 74 | 75 72 6e 2e 20 20 20 54 |or a Ret|urn. T|
|00005aa0| 68 65 20 72 65 73 74 20 | 20 6f 66 20 20 74 68 65 |he rest | of the|
|00005ab0| 20 4c 61 62 65 6c 20 20 | 66 6f 72 6d 75 6c 61 20 | Label |formula |
|00005ac0| 69 73 0d 73 65 6c 66 2d | 65 78 70 6c 61 6e 61 74 |is.self-|explanat|
|00005ad0| 6f 72 79 2e 20 20 20 45 | 73 70 65 63 69 61 6c 6c |ory. E|speciall|
|00005ae0| 79 20 20 6e 6f 74 65 20 | 74 68 65 20 75 73 65 20 |y note |the use |
|00005af0| 20 6f 66 20 74 68 65 20 | 52 65 74 75 72 6e 73 20 | of the |Returns |
|00005b00| 20 61 6e 64 20 74 68 65 | 20 63 6f 6d 6d 61 0d 69 | and the| comma.i|
|00005b10| 6e 73 65 72 74 65 64 20 | 61 66 74 65 72 20 43 69 |nserted |after Ci|
|00005b20| 74 79 2e ff 02 00 4b ff | 02 00 4b 54 68 65 72 65 |ty....K.|..KThere|
|00005b30| 20 69 73 20 6a 75 73 74 | 20 65 6e 6f 75 67 68 20 | is just| enough |
|00005b40| 20 74 69 6d 65 20 66 6f | 72 20 20 6f 6e 65 20 6d | time fo|r one m|
|00005b50| 6f 72 65 20 73 74 72 69 | 6e 67 20 66 75 6e 63 74 |ore stri|ng funct|
|00005b60| 69 6f 6e 20 20 65 78 61 | 6d 70 6c 65 2e 20 20 53 |ion exa|mple. S|
|00005b70| 75 70 70 6f 73 65 0d 79 | 6f 75 20 77 61 6e 74 65 |uppose.y|ou wante|
|00005b80| 64 20 20 74 6f 20 70 72 | 69 6e 74 20 74 68 65 20 |d to pr|int the |
|00005b90| 20 66 69 72 73 74 20 69 | 6e 69 74 69 61 6c 20 6f | first i|nitial o|
|00005ba0| 6e 20 20 74 68 65 20 6c | 61 62 65 6c 73 20 69 6e |n the l|abels in|
|00005bb0| 73 74 65 61 64 20 20 6f | 66 20 74 68 65 20 66 75 |stead o|f the fu|
|00005bc0| 6c 6c 0d 66 69 72 73 74 | 20 6e 61 6d 65 2e 20 20 |ll.first| name. |
|00005bd0| 20 57 68 61 74 20 66 75 | 6e 63 74 69 6f 6e 20 6d | What fu|nction m|
|00005be0| 69 67 68 74 20 68 65 6c | 70 20 75 73 20 64 6f 20 |ight hel|p us do |
|00005bf0| 69 74 3f 20 20 20 54 68 | 65 20 61 6e 73 77 65 72 |it? Th|e answer|
|00005c00| 20 69 73 20 40 6d 69 64 | 2e 20 54 68 69 73 0d 66 | is @mid|. This.f|
|00005c10| 75 6e 63 74 69 6f 6e 20 | 69 73 20 75 73 65 64 20 |unction |is used |
|00005c20| 77 68 65 6e 20 79 6f 75 | 20 77 61 6e 74 20 74 6f |when you| want to|
|00005c30| 20 73 65 6c 65 63 74 20 | 61 20 20 70 6f 72 74 69 | select |a porti|
|00005c40| 6f 6e 20 6f 66 20 61 20 | 20 73 74 72 69 6e 67 2e |on of a | string.|
|00005c50| 20 20 49 74 20 74 61 6b | 65 73 0d 74 68 72 65 65 | It tak|es.three|
|00005c60| 20 61 72 67 75 6d 65 6e | 74 73 3a 20 20 61 20 73 | argumen|ts: a s|
|00005c70| 74 72 69 6e 67 2c 20 61 | 20 73 74 61 72 74 69 6e |tring, a| startin|
|00005c80| 67 20 70 6f 73 69 74 69 | 6f 6e 2c 20 61 6e 64 20 |g positi|on, and |
|00005c90| 61 20 6c 65 6e 67 74 68 | 2e 20 48 65 72 65 20 69 |a length|. Here i|
|00005ca0| 73 20 77 68 61 74 0d 6f | 75 72 20 6d 6f 64 69 66 |s what.o|ur modif|
|00005cb0| 69 65 64 20 6c 61 62 65 | 6c 20 66 69 65 6c 64 20 |ied labe|l field |
|00005cc0| 66 6f 72 6d 75 6c 61 20 | 6c 6f 6f 6b 73 20 6c 69 |formula |looks li|
|00005cd0| 6b 65 3a ff 02 00 4b ff | 02 00 4b 20 20 20 20 20 |ke:...K.|..K |
|00005ce0| 4c 61 62 65 6c 20 3a 3d | 20 54 69 74 6c 65 20 26 |Label :=| Title &|
|00005cf0| 20 22 20 22 20 26 ff 02 | 00 4b 20 20 20 20 20 20 | " " &..|.K |
|00005d00| 20 20 20 20 20 20 20 20 | 40 6d 69 64 28 46 69 72 | |@mid(Fir|
|00005d10| 73 74 2c 31 2c 31 29 20 | 26 20 22 2e 20 22 20 26 |st,1,1) |& ". " &|
|00005d20| ff 02 00 4b 20 20 20 20 | 20 20 20 20 20 20 20 20 |...K | |
|00005d30| 20 20 4c 61 73 74 20 20 | 26 20 22 20 22 20 26 20 | Last |& " " & |
|00005d40| 40 63 68 72 28 31 33 29 | 20 26 ff 02 00 4b 20 20 |@chr(13)| &...K |
|00005d50| 20 20 20 20 20 20 20 20 | 20 20 20 20 41 64 64 72 | | Addr|
|00005d60| 65 73 73 20 20 20 20 20 | 26 20 40 63 68 72 28 31 |ess |& @chr(1|
|00005d70| 33 29 20 26 ff 02 00 4b | 20 20 20 20 20 20 20 20 |3) &...K| |
|00005d80| 20 20 20 20 20 20 43 69 | 74 79 20 20 20 20 20 20 | Ci|ty |
|00005d90| 20 20 26 20 22 2c 20 22 | 20 26 ff 02 00 4b 20 20 | & ", "| &...K |
|00005da0| 20 20 20 20 20 20 20 20 | 20 20 20 20 53 74 61 74 | | Stat|
|00005db0| 65 20 26 20 22 20 22 20 | 26 20 5a 69 70 ff 02 00 |e & " " |& Zip...|
|00005dc0| 4b ff 02 00 4b 40 6d 69 | 64 20 74 61 6b 65 73 20 |K...K@mi|d takes |
|00005dd0| 74 68 65 20 66 69 72 73 | 74 20 63 68 61 72 61 63 |the firs|t charac|
|00005de0| 74 65 72 20 6f 66 20 46 | 69 72 73 74 20 61 6e 64 |ter of F|irst and|
|00005df0| 20 66 6f 6c 6c 6f 77 73 | 20 69 74 20 77 69 74 68 | follows| it with|
|00005e00| 20 61 20 70 65 72 69 6f | 64 20 20 61 6e 64 20 61 | a perio|d and a|
|00005e10| 0d 73 70 61 63 65 2e 20 | 20 20 50 72 65 74 74 79 |.space. | Pretty|
|00005e20| 20 73 69 6d 70 6c 65 2c | 20 69 73 6e 27 74 20 69 | simple,| isn't i|
|00005e30| 74 3f 20 20 54 68 69 6e | 6b 20 61 62 6f 75 74 20 |t? Thin|k about |
|00005e40| 74 68 65 20 73 74 72 69 | 6e 67 73 20 69 6e 20 79 |the stri|ngs in y|
|00005e50| 6f 75 72 20 70 72 6f 67 | 72 61 6d 73 0d 61 73 20 |our prog|rams.as |
|00005e60| 63 6f 6c 6c 65 63 74 69 | 6f 6e 73 20 20 6f 66 20 |collecti|ons of |
|00005e70| 63 68 61 72 61 63 74 65 | 72 73 2c 20 20 61 6e 64 |characte|rs, and|
|00005e80| 20 79 6f 75 20 63 61 6e | 20 6d 61 6e 69 70 75 6c | you can| manipul|
|00005e90| 61 74 65 20 20 74 68 65 | 20 63 68 61 72 61 63 74 |ate the| charact|
|00005ea0| 65 72 73 20 6c 69 6b 65 | 0d 62 75 69 6c 64 69 6e |ers like|.buildin|
|00005eb0| 67 20 62 6c 6f 63 6b 73 | 2c 20 75 73 69 6e 67 20 |g blocks|, using |
|00005ec0| 74 68 65 20 73 74 72 69 | 6e 67 20 66 75 6e 63 74 |the stri|ng funct|
|00005ed0| 69 6f 6e 73 20 61 6e 64 | 20 74 68 65 20 61 6d 70 |ions and| the amp|
|00005ee0| 65 72 73 61 6e 64 20 74 | 6f 20 6d 61 6e 69 70 75 |ersand t|o manipu|
|00005ef0| 6c 61 74 65 0d 79 6f 75 | 72 20 73 74 72 69 6e 67 |late.you|r string|
|00005f00| 20 64 61 74 61 20 69 6e | 74 6f 20 61 6e 79 20 66 | data in|to any f|
|00005f10| 6f 72 6d 20 79 6f 75 20 | 6c 69 6b 65 2e ff 02 00 |orm you |like....|
|00005f20| 4b ff 02 00 4b 54 68 61 | 74 27 73 20 61 62 6f 75 |K...KTha|t's abou|
|00005f30| 74 20 69 74 20 66 6f 72 | 20 74 68 65 20 69 6e 74 |t it for| the int|
|00005f40| 72 6f 64 75 63 74 69 6f | 6e 20 74 6f 20 76 61 6c |roductio|n to val|
|00005f50| 75 65 20 66 75 6e 63 74 | 69 6f 6e 73 2e 20 20 20 |ue funct|ions. |
|00005f60| 54 68 65 20 20 6f 6e 6c | 79 20 77 61 79 20 74 6f |The onl|y way to|
|00005f70| 0d 62 65 63 6f 6d 65 20 | 72 65 61 6c 6c 79 20 70 |.become |really p|
|00005f80| 72 6f 66 69 63 69 65 6e | 74 20 77 69 74 68 20 61 |roficien|t with a|
|00005f90| 6c 6c 20 6f 66 20 74 68 | 65 6d 20 69 73 20 20 74 |ll of th|em is t|
|00005fa0| 6f 20 74 72 79 20 65 61 | 63 68 20 6f 6e 65 20 20 |o try ea|ch one |
|00005fb0| 79 6f 75 72 73 65 6c 66 | 2e 20 4f 66 0d 63 6f 75 |yourself|. Of.cou|
|00005fc0| 72 73 65 2c 20 20 49 27 | 6d 20 20 68 6f 70 69 6e |rse, I'|m hopin|
|00005fd0| 67 20 74 68 61 74 20 6f | 75 72 20 65 78 63 75 72 |g that o|ur excur|
|00005fe0| 73 69 6f 6e 73 20 20 66 | 72 6f 6d 20 74 68 65 20 |sions f|rom the |
|00005ff0| 20 61 72 6d 63 68 61 69 | 72 20 77 69 6c 6c 20 73 | armchai|r will s|
|00006000| 74 69 6d 75 6c 61 74 65 | 0d 79 6f 75 72 20 63 75 |timulate|.your cu|
|00006010| 72 69 6f 73 69 74 79 20 | 61 6e 64 20 74 65 6d 70 |riosity |and temp|
|00006020| 74 20 79 6f 75 20 74 6f | 20 65 78 70 65 72 69 6d |t you to| experim|
|00006030| 65 6e 74 2e 20 4e 65 78 | 74 20 74 69 6d 65 2c 20 |ent. Nex|t time, |
|00006040| 69 6e 20 50 61 72 74 20 | 33 2c 20 49 20 77 69 6c |in Part |3, I wil|
|00006050| 6c 20 62 65 0d 64 69 73 | 63 75 73 73 69 6e 67 20 |l be.dis|cussing |
|00006060| 6c 6f 6f 70 69 6e 67 20 | 61 6e 64 20 74 65 73 74 |looping |and test|
|00006070| 69 6e 67 2c 20 74 77 6f | 20 76 65 72 79 20 69 6d |ing, two| very im|
|00006080| 70 6f 72 74 61 6e 74 20 | 63 6f 6e 63 65 70 74 73 |portant |concepts|
|00006090| 20 66 6f 72 20 63 6f 6e | 74 72 6f 6c 6c 69 6e 67 | for con|trolling|
|000060a0| 0d 79 6f 75 72 20 70 72 | 6f 67 72 61 6d 73 2e 20 |.your pr|ograms. |
|000060b0| 55 6e 74 69 6c 20 74 68 | 65 6e 2c 20 6d 61 79 20 |Until th|en, may |
|000060c0| 46 52 45 44 20 62 65 20 | 77 69 74 68 20 79 6f 75 |FRED be |with you|
|000060d0| 2e ff 02 00 ff ff 02 00 | 4b 00 ff ff ff ff ff ff |........|K.......|
|000060e0| 04 00 3c 01 02 00 07 61 | 01 00 01 00 4c 00 11 00 |..<....a|....L...|
|000060f0| 02 00 03 00 4d 00 13 00 | 01 00 02 00 4e 00 14 00 |....M...|....N...|
|00006100| 01 00 02 00 4e 00 14 00 | 04 00 03 00 0f 06 00 00 |....N...|........|
|00006110| 00 00 00 00 00 00 00 00 | 4b 05 06 00 00 4b 00 00 |........|K....K..|
|00006120| 03 00 3e 01 18 82 00 00 | 00 01 00 00 02 00 16 00 |..>.....|........|
|00006130| 41 72 6d 63 68 61 69 72 | 20 46 52 45 44 20 2d 20 |Armchair| FRED - |
|00006140| 50 61 72 74 20 32 00 ff | ff ff ff ff ff ff ff ff |Part 2..|........|
|00006150| 02 00 40 01 18 82 00 00 | 00 01 00 00 02 00 03 00 |..@.....|........|
|00006160| 40 6e 70 00 ff ff ff ff | ff ff ff ff ff ff ff ff |@np.....|........|
|00006170| a5 02 42 01 18 80 00 00 | 00 02 00 00 02 00 00 00 |..B.....|........|
|00006180| 00 00 00 00 00 00 00 00 | b9 08 1c 02 c0 08 01 00 |........|........|
|00006190| 02 00 4a 29 0d 02 20 20 | 20 20 20 62 79 20 4b 65 |..J).. | by Ke|
|000061a0| 6e 74 20 49 72 77 69 6e | ff 02 00 4b ff 02 00 4b |nt Irwin|...K...K|
|000061b0| ff 02 00 4b 00 04 49 6e | 74 72 6f 64 75 63 74 69 |...K..In|troducti|
|000061c0| 6f 6e ff 02 00 4b 00 00 | 54 68 65 20 74 72 61 76 |on...K..|The trav|
|000061d0| 65 6c 65 72 20 73 6c 6f | 77 6c 79 20 77 69 70 65 |eler slo|wly wipe|
|000061e0| 64 20 74 68 65 20 73 77 | 65 61 74 20 66 72 6f 6d |d the sw|eat from|
|000061f0| 20 68 69 73 20 62 72 6f | 77 20 20 61 6e 64 20 73 | his bro|w and s|
|00006200| 65 74 20 68 69 73 20 70 | 61 63 6b 20 20 6f 6e 20 |et his p|ack on |
|00006210| 74 68 65 0d 67 72 6f 75 | 6e 64 2e 20 20 20 53 6f |the.grou|nd. So|
|00006220| 20 66 61 72 20 68 69 73 | 20 6a 6f 75 72 6e 65 79 | far his| journey|
|00006230| 20 68 61 64 20 62 65 65 | 6e 20 6c 6f 6e 67 20 61 | had bee|n long a|
|00006240| 6e 64 20 65 76 65 6e 74 | 66 75 6c 2c 20 77 69 74 |nd event|ful, wit|
|00006250| 68 20 6d 61 6e 79 20 74 | 75 72 6e 69 6e 67 73 0d |h many t|urnings.|
|00006260| 6f 66 20 74 68 65 20 72 | 6f 61 64 2e 20 20 20 42 |of the r|oad. B|
|00006270| 75 74 20 75 6e 74 69 6c | 20 6e 6f 77 20 74 68 65 |ut until| now the|
|00006280| 72 65 20 68 61 64 20 62 | 65 65 6e 20 20 6f 6e 6c |re had b|een onl|
|00006290| 79 20 20 6f 6e 65 20 72 | 6f 61 64 2e 20 20 20 42 |y one r|oad. B|
|000062a0| 65 67 69 6e 6e 69 6e 67 | 20 74 6f 0d 66 65 65 6c |eginning| to.feel|
|000062b0| 20 72 65 73 74 65 64 2c | 20 20 74 68 65 20 20 74 | rested,| the t|
|000062c0| 72 61 76 65 6c 65 72 20 | 20 74 6f 6f 6b 20 61 20 |raveler | took a |
|000062d0| 6c 6f 6e 67 20 73 77 69 | 67 20 20 66 72 6f 6d 20 |long swi|g from |
|000062e0| 68 69 73 20 20 63 61 6e | 74 65 65 6e 20 61 6e 64 |his can|teen and|
|000062f0| 20 73 74 61 72 65 64 0d | 61 68 65 61 64 20 61 74 | stared.|ahead at|
|00006300| 20 74 68 65 20 66 6f 72 | 6b 2e 20 20 20 57 69 74 | the for|k. Wit|
|00006310| 68 6f 75 74 20 61 20 64 | 6f 75 62 74 2c 20 20 61 |hout a d|oubt, a|
|00006320| 20 64 65 63 69 73 69 6f | 6e 20 68 61 64 20 74 6f | decisio|n had to|
|00006330| 20 62 65 20 6d 61 64 65 | 2e 20 57 68 69 63 68 20 | be made|. Which |
|00006340| 77 61 79 0d 74 6f 20 67 | 6f 3f ff 02 00 4b ff 02 |way.to g|o?...K..|
|00006350| 00 4b 44 65 63 69 73 69 | 6f 6e 73 20 61 72 65 20 |.KDecisi|ons are |
|00006360| 61 6e 20 69 6d 70 6f 72 | 74 61 6e 74 20 70 61 72 |an impor|tant par|
|00006370| 74 20 6f 66 20 61 6e 79 | 20 74 61 73 6b 2e 20 20 |t of any| task. |
|00006380| 49 6e 20 74 72 61 76 65 | 6c 69 6e 67 2c 20 79 6f |In trave|ling, yo|
|00006390| 75 20 6d 75 73 74 20 64 | 65 63 69 64 65 0d 77 68 |u must d|ecide.wh|
|000063a0| 69 63 68 20 70 61 74 68 | 73 20 77 69 6c 6c 20 74 |ich path|s will t|
|000063b0| 61 6b 65 20 79 6f 75 20 | 69 6e 20 74 68 65 20 64 |ake you |in the d|
|000063c0| 69 72 65 63 74 69 6f 6e | 20 79 6f 75 20 77 69 73 |irection| you wis|
|000063d0| 68 20 20 74 6f 20 20 67 | 6f 2e 20 20 20 49 6e 20 |h to g|o. In |
|000063e0| 46 52 45 44 20 70 72 6f | 2d 0d 67 72 61 6d 6d 69 |FRED pro|-.grammi|
|000063f0| 6e 67 2c 20 20 79 6f 75 | 20 6d 75 73 74 20 6d 61 |ng, you| must ma|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.
